By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Help with Query

P: n/a
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.

Jun 15 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Jun 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.