Help with Query

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.

tboyd24@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.