Simplest way to do multiple query totals on one form/report

[englishkid19]

Hi All,
sure this has been covered off before but I cant find the exact solution.

I have 16 queries all related to one table.

The information required for a summary report is a count of records returned from all of the 16 queries. Is their a quick and dirty way of getting the COUNT value from all 16 queries on one page. ?

Thnaks Tom

 

[Joe4]

Two things to look into:

If you are just looking for a straight count, take a look at the DCOUNT function. See: MS Access: DCount Function
Note that if you just want the straight count, there is a good chance you won't need to use the third argument (Criteria).

The other option is to do Subforms/Subreports. Check out the Help files or do a Google search to find a myriad of articles and tutorials on that.