Query with Date

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

I am trying to sumarize information by year, but if an
event occurs twice on the same date, it is counted as one
occurence and not two. How do I rectify this situation.
 
You Group By it in Query 1.
Then use results of Query 1 in Query2.
 
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

Hello, I have multiple products, in a query I want to condense to 2
Summarize dates for like records 2
Summary Queries. 7
Calculating fiscal year for two dates in query 5
Query with count, but what am I counting?! 4
Combining 2 tables 4
Date Query 2
Return multiple records from a single entry. 2

Back
Top