date difference

[joe789]

Hey folks,

I use to know how to perform such a query, but haven't in so long I am lost ... hopefully someone can help.

I have a very simple base table that has a unique person identifier as well as a unique date of service. I have the table sorted by unique person identifier then by unique date of service for that person. I am attempted to create a query whereby any lapse in service for an individual that is greater than 90 days is counted once.

Any help would be appreciate.


Thanks,

Joe

 

[pbaldy]

One method that comes to mind is a previous values query, where you pull in the date from the previous record into the current record so you can compare the two.