Summary Sheet


H

Hendrix

I 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.
 
Ad

Advertisements

J

John W. Vinson

I 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summaries of summaries.. 1
Summary 1
system summary 1
report summary 1
summary query 5
Summary Table 0
Summary query, sum by 1
Sorting in a summary report 2

Top