Counting Ocurrances within a Time Frame

  • Thread starter Thread starter Gringarlow
  • Start date Start date
G

Gringarlow

I need to find each time a code occurs 5 or more times in a 7 day period.
Example:
CodeA and Town are fields in tblHelpr that I add rows of data to every
morning.
My query will run after the table is updated.
If CodeA occurs in a specific Town 5 or more times in the last 7 days, I
need to see that in my query.
 
SELECT tblHelpr.Town,
tblHelpr.CodeA,
Count(tblHelpr.CodeA) AS CountOfCodeA
FROM tblHelpr
WHERE tblHelpr.TheDate > Date()-7
GROUP BY tblHelpr.Town,
tblHelpr.CodeA
HAVING Count(tblHelpr.CodeA>5;

You didn't say the date field name so change TheDate to the proper field name.
 

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

Using the highest count for the field name in a query 2
Running Count within a Group (Time-Zero Data) 7
Coronavirus Preparation 183
Combine Duplicates in Query 0
How is everyone doing? 23
Query pulling Time-Framed values 1
Count Query Help 1
FUNCTION PREDICTING EVEN/ODD COUNT IN QUERY 1

Back
Top