Rollup funtion in Access

[Mike]

Good morning, I have a report that runs off of a query.
The report rolls up the warehouses with a total after each
one. When I export the report into excel I loose my totals
and the format looks trerible.
Does Access have a rollup funtion like other SQL programs?
If so can I use the rollup funtion and sum the infomation?
This way I can run a query and export it to excel.

 

[Guest]

Hi Mike,
Sounds like a job for a Totals query - a variation on the
Select query. Click on the "sigma" toolbar button in
query design mode; Group By "warehouse" and change Group
By to Sum for the appropriate numeric fields.

Hope this helps