Total of sum field (1 Viewer)

[MaxTO]

This is what my query looks like at the moment:

Field: Issue,Rejected,Inspected,Area
Total: Group By,Sum,Sum,Where
Criteria:,,,[Area:]

What I'd like to have is a calculated field after "Inspected" which would show the grand total of all "Inspected" for that "Area".

Example:
Issue, Rejected, Inspected, Total Inspected
Scratched, 5, 100, 130
Chipped, 1, 10, 130
Dented, 2, 20, 130

Any ideas on how to get the "Total Inspected" field?

Thanks!

 

[Matty]

I think you'll have to do a second query to get the totals, or put that query behind a report, group the report by Area and put a sum in the group footer.