Totaling tables in a Report

[ChrisBair]

Have a inventory report showing the total of each item.
Using a UnitsOnHand quesry(taking out damages and quarantine- UnitsOnHand: Sum(IIf([WarehouseName]<>"Quarantined" And [WarehouseName]<>"Damaged" And [WarehouseName]<>"King Street Office",[TotalUnits],0))

No i want to add that together in one total on the report.

Any suggestions?

thnaks

 

[Frink]

Hallo,

Doesn't Access have a Sum function you can use on reports.
I seem to remember the Wizard putting totals in for auto-generated reports.

- Frink