prabhafriend
07-23-2014, 07:32 AM
=IF(OR(WEEKDAY(CX1480,2)=6,WEEKDAY(CX1480,2)=7,COUNTIF('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...
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...