Post by HendrixI have set up a data base that runs a few seperate queries. I wanted
to know if there was a way to set up a summary sheet the has the
totals of each query.
Well, you don't give much to go on, but yes; you could create a Report with
Subreports for the queries, and totals in the footers of the subreports.
If you're using query datasheets to display the results of the query....
don't. Datasheets are good for debugging and initial design but they're not
designed or intended for data presentation. Reports are much more capable;
they have Sorting and Grouping that let you do grand totals, subtotals,
sub-sub totals, flexible layout, etc.
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com