Converting this formula to an access database

[prabha_friend]

=IF(OR(WEEKDAY(CX1480,2)=6,WEEKDAY(CX1480,2)=7,COU NTIF('C:\Documents and Settings\karuppsp\Desktop\My Projects\SLA - C11\[Holiday Calendar FR Freight.xlsx]Holiday Calendar FR Freight'!$D$5:$D$14,CX1480)>0),TRUE,FALSE)




I have created the Holiday Calendar in a table named Holidays. I know I have to use a subquery here but I haven't used it before. Please help. I have created the following column in a query with the following expression:

Ap Inquiry: IIf(Weekday([Received Date],2)=6 Or Weekday([Received Date],2)=7 Or (Subquery Here),True,False)

Thanks in advance...

[pbaldy]

As answered elsewhere, a DCount(), and regarding a subquery:

I'm not sure a subquery would be faster than a domain function, and not sure how you'd incorporate it there. Personally I'd probably create a function that took the date as an input parameter and returned the Boolean. Written correctly it would only look for holidays when the date failed the first 2 tests.