Records within 30 days of each other

[NSTLouis]

I have a database of service requests. Each service request is given an entry date. I need a query to tell me if we have 3 requests for the same service within 30 days of each other. So, the 30 days is a moving target. I don't want 3 requests within a specific 30 day time frame. Any ideas on how to set the criteria for [EntryDate] so that Access looks back for matching records and only returns matches that are within 30 days of each other?

Thanks

 

[dcx693]

Interesting problem. I can't think of a sure solution right off, but I can think of two ways to do this that might work.

First, a crosstab query that would take each service request in a row and show the number of same service requests that had occurred within 30 days either side of that service request in two columns.

Second, some VBA code that would do more or less the same thing programatically.

 

[Kelly]

Hi did you get any answer to this? I also need a query which will only show records that fall within a 30 day period. I actually need to extract the record if it has occurred 3 times within a 30 day period. It must be possible just not the ways I am trying.

Can you help

Thanks

 

[namliam]

Dont re-surrect an ancient thread like this AND start your own...

Either/or will do maybe link this thread in your new one.

 

[Kelly]

When I asked the question using the old thread the site said I was logged out, so I never realised it had posted my question. Sorry not up on forum etiquette.