Help with Query

[tboyd24]

Is there a way to show data based on if dates are consecutive. Im try
to show only the people who have consecutive Vac days out of a list of
20,000 records.

[salad]

tb*****@hotmail.com wrote:

Is there a way to show data based on if dates are consecutive. Im try
to show only the people who have consecutive Vac days out of a list of
20,000 records.

At first I thought you could get the max and min dates and count grouped
on employeeID and save to a query. Then Select those where
maxday-minday+1 = countofdays. But that wouldn't work because the date
range might be so large...maybe data over 2 weeks...there'd be gaps
because of weekends.

The best thing to do would be to write a function with your rules and
call the function within the query.