ADO data shape

Hi,


PPPPPlease HElllllp.

I am currently building a vb golf score analyser in VB6 I decided to
use data reports instead of crystal. Everything was going fine until I
wanted to group my report via division
I use ADO to send the sql to the data report which is working fine.
What I cant do Is change the sql line below to a data shape that
groups all records into divisions. I have a division field which can
be division1, division2 etc. The sql line that works is:

Select * from score where strdate between #27-Mar-03# and #28-Mar-04# order by net 

I need to group the above by division in the report to display like eg

division1
          Joe Bloggs            71
          Pete Smith            76
          Roger Rabitt          82

Division2
           Graham Blimey       76
            Peter pan               82
           Jimmey decricket    86

Division3
           Father Christmas       81
           Layton Buzzard         84
           Joe Pascwaley          91

Thanks in advance

did you try adding a 'group by' clause? for example:

Select * from score where strdate between #27-Mar-03# and #28-Mar-04#
group by division order by net