Counts by dates

  • Thread starter Thread starter John
  • Start date Start date
J

John

How do I enter a query to count records by specific dates
within five or more tables
 
Vague response to vague question.

Use a UNION ALL query as the source of a Totals (aggregate) query.

or try something like

SELECT Sum(RecordCount) as TotalRecords
FROM (
SELECT Count(*) as RecordCount
FROM TableA
WHERE SomeDate = SomeCriteriaDate
UNION ALL
SELECT Count(*)
FROM TableB
WHERE SomeDate = SomeCriteriaDate
UNION ALL
SELECT Count(*)
FROM TableC
WHERE SomeDate = SomeCriteriaDate)
 
Why not the same way you would do this with a single query only do it five
or more times?
 
You must log in or register to reply here.

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

Count by short date and group by agent name 6
Dcount returning no results!!! 0
Access Dcount function in access 0
minimize repeating query criteria & generating monthly YTD totals 1
Counting checkboxes between two dates 2
Subquery select field from previous record 4
How to count consecutive records base on 2 groupings 0
How to Populate Data from a table to another 0

Back
Top