Multiple sources for Reports

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

Dean Mattoon

I am trying to assemble a report which would use fields from different
queries. Is this possible?
 
Dean

Perhaps not quite enough information...

Typically in Access, you'd have a report based on a single query. How is it
that you have multiple queries that all "feed" the same report?

If you'll provide an example of the SQL statements for a couple of those
queries, it may be that folks here can offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks, I will try to explain it better, and I am not sure how to generate an
SQL statement..

I work for a stormwater department. The access database I created to track
all of the inspections and things we do for our stormwater permit. So I have
a table that has all of my construction site inspections, as well as separate
tables for water quality inspection, post construction, violations, etc. I
would like to generate queries that totals up the number of inspections
performed in a given year for each of those tables, and then be able to have
those "counted" fields show up in a report. Does that make more sense?

Thanks so much for your fast reply!
 
If all you want to do is show counts by year, then you should be able to use
a union query like:
SELECT "Water Quality" as Source, Year(InspDate) as Yr, Count(*) as NumInsp
FROM tblWaterQuality
GROUP BY Year(InspDate)
UNION ALL
SELECT "Post Construction", Year(InspDate), Count(*)
FROM tblPostConstruction
GROUP BY Year(InspDate)
UNION ALL
--- etc ---
You can then filter this by year.
 
Back
Top