Grouping on a Form

[Guest]

I want to group like I would on a report, only on a form: Something similar
to the below. The dept number and amounts are in a table and then the dept
numbers and the manager is in another table.


Manager1
Dept 100, amount
Dept 200, amount
Dept 300, amount

Manager2
Dept 500, amount
Dept 600, amount

Manager3
Dept 700, amount
Dept 800, amount

Any help?

 

[Guest]

Use sort in the query.

 

[Guest]

Sorry, I should have been more clear. I want to show the subtotals by
Manager for each of the the departments they are responsible for.

Just as you would do on a report, only I want to do it on the form.

 

[Guest]

Try using subforms.

Sorry, I should have been more clear. I want to show the subtotals by
Manager for each of the the departments they are responsible for.

Just as you would do on a report, only I want to do it on the form.