Remove weekday holiday dates from "between dates"

W

willh

I have a query that calcs the weekdays between 2 specific dates entered as
perameter values and calcs if they are less that 10 days. How to I get it to
ignore specic holiday dates (e.g .christmas) that maybe weekdays. Can I put
these dates into the expression or in a separate table which the query then
calls, or set up some criteria to ignore these specific dates in the weekday
calc. The query is below....

RLAMND Is Not Null And Between [Enter First Date] And [Enter Last Date]
Days Taken: WeekDays([DEPOSD],[RLAMND])
Target Met: IIf([Days Taken]<=10,1,0)

where DEPOSD & RLAMND are date fields in a table

I tried "and is not 25/12/2008" in the criteria but this didn't make any
difference

Cheers
 
A

Al Campagna

willh,
On my website (below) I have a 97 and 2003 sample file called Calculate
Number of Workdays.
Given a StartDate and EndDate, it determines how many "workdays" there
are between the two values.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Top