data grouping

[ultimatewilliam]

hi everyone im back with my new problem..

i have these records..

fld1 fld2 fld3
CCC 001 00
CCC 001 03
CCC 001 02
BBB 003 00
BBB 003 01
AAA 002 00
AAA 002 01
AAA 002 02

i need to group these records so it would look like this


AAA 002 00
AAA 002 01
AAA 002 02

BBB 003 00
BBB 003 01

CCC 001 00
CCC 001 02
CCC 001 03

they are grouped by Fld2 but sorted acendingly by Fld1.

thanks in advance!

 

[Madawc]

Use both field 1 and field 2 as groups, with 1 as the higher group. That would do it for the data you showed, definitely.

Madawc Williams (East Anglia, UK)

 

[ultimatewilliam]

hey thanks madawc! but.. do you mean i'll only have one group? -that is the combination of feild1 and feild2? i'll try it then.. thanks!

 

[Madawc]

I meant two groups: you can suppress headers and footers and make the group invisible. But you're right, a group based on the two fields should work.

Madawc Williams (East Anglia, UK)