Trying to bring 5-6 small queries into one report

  • Thread starter Thread starter Dean Mattoon
  • Start date Start date
D

Dean Mattoon

I have created a database for our city's stormwater permit. I would like to
be able to generate a report that has totals for all the different
construction sites, post construction sites, illicit discharge sites, etc. I
can't seem to get the totals right by querying them all together based on a
common field, and access doesn't appear to allow me to create a report based
on 2 or more queries. Any suggestions anyone? Thanks in advance for any help.
 
It sounds like they would all have same fields so you could use a union query
to pull them together and add a text field designating the type of data -
construction sites, post construction sites, illicit discharge sites, etc.

If unable to do that then you can use Subreports.
 
Back
Top