Showing sum in reports

[Waheed2008]

I have a table Table1 having the fields
ID, Department, Expense, etc.

Each department has many expenses that are listed in this table. I want to generate a report such that on a page all the table fields will be displayed AND the total expense of each department should also be there. Each page will have total expense of department displayed on that page.

How should I do that? can any budy help me ?

Thanks

 

[Brianwarnock]

How very similar to the query I've just replied to. Please don't ddouble post.

You should group be Dept and show the total in the group footer.

Brian