question on performing searches

  • Thread starter Thread starter Daniel Melero
  • Start date Start date
D

Daniel Melero

I need to write a query or some code to perform a search
on my database. Here is what I need:
I need to perform a search on stores that are late for 3
times between date 'X' and date 'Y'. I have to search
through my Call_Log table for Stores that have 3 entries
between the dates given. Can someone help? If you need
more information or are not clear about what i wrote, I
will be happy to clarify? Thanks in advance.
 
Dear Daniel:

Generally speaking (and, when you give only general information in
your question, you're going to get a much more general response) you
will have an aggregate query that counts these occurrances of being
late, using the filter between dates X and Y. Once you are able to
count these occurrances, you can also filter by this value. That
would occur in a HAVING clause.

Grouping by store, you could probably just add:

HAVING COUNT(*) >= 3

For a more detailed response, please give more details in the
question.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top