Thanks for the replies.

I've tried this suggestion and as suspected it still produces the error.
When I try to add totals to the query I this syntax error upon running:
[IMGnothumb]http://img94.imageshac k.us/img94/9594/errortmn.png[/IMGnothumb]

I am working on building a series of queries and reports based on a database so my associates can simply click on the reports and get important figures. I've run into a problem when it comes to aggregates based on a query with a subquery in it.

I'm used to using PHP and MYSQL to run queries and manage databases, so I'm new to Access syntax and limitations. I'm building these reports in Access 2010.

An example of the...