How to get working days in the query?

Schlingel

Registered User.
Local time
Today, 06:22
Joined
Oct 26, 2006
Messages
32
Hi, i have a problem
I need to create a query that shows me only days which r:
1. working days
2. which r not in the table on which the query is based
Thanks in advance
 
Seems to me that you would have to generate a table with a list of all working days for a given period. Take out holidays. Then run an unmatched query between the two tables. I expect that you would use DateAdd in a loop adding + 1 to a specific starting date, check to see if it is a workday (Mon - Fri?) and not a holiday (in a table of holidays?) and, if so, append it to the Workdays table.
 

Users who are viewing this thread

Back
Top Bottom