Sorting/grouping

[aerosmith]

I have a join query in which i need a little bit of help what im trying display the content in groups

Example

the table is split into 4 fields

Name Code Amount Manager
BOB1 039 100 Dave
BOB2 099 100 Ken
BOB3 066 100 Barbie
BOB4 039 100 Dave



What i want to display in a report would be



Dave
BOB1 039 100
BOB4 039 100

Barbie
BOB3 066 100

Ken
BOB2 099 100

Can someone point me in the right direction as to where to start something like this,

 

[pbaldy]

The report wizard should ask you if you want to group on any fields. If you select Manager, you should get you pretty close to what you want.

 

[thatlem]

If you do a sort and define the Manager's name field, the report will add a header for the sort into which you can add the Manager's name field. Then just add the other fields into the details section. When you run the report you should get what you want..