SELECT tblLeaveBalance_Cashables1.Facility, tblLeaveBalance_Cashables1.Division, tblLeaveBalance_Cashables1.Position, tblLeaveBalance_Cashables1.Name, tblLeaveBalance_Cashables1.[Class Code], tblLeaveBalance_Cashables1.Class_Title AS Classification, tblLeaveBalance_Cashables1.CBID, tblLeaveBalance_Cashables1.[SS Months], tblLeaveBalance_Cashables1.Age, tblLeaveBalance_Cashables1.BasePay, tblLeaveBalance_Cashables1.[Hourly Rate], tblLeaveBalance_Cashables1.[Annual Leave], tblLeaveBalance_Cashables1.[AL Total $], tblLeaveBalance_Cashables1.[Personal Holiday], tblLeaveBalance_Cashables1.[Personal Holiday (Hours)], tblLeaveBalance_Cashables1.[PH Total $], tblLeaveBalance_Cashables1.Vacation, tblLeaveBalance_Cashables1.[VA Total $], tblLeaveBalance_Cashables1.[Total Hours], tblLeaveBalance_Cashables1.[Total Hours $]
FROM tblLeaveBalance_Cashables1
WHERE (((([Vacation]>640) or ([Annual Leave]>640)) And ([Personal Holiday (Hours)]>24)) AND ([tblLeaveBalance_Cashables1].[CBID]) In ("M06") and ("S06") and ("R06")
I need to extract data that where vacation time is >640 or annual leave is >640 and where personal Hol hours are >24 and CBID is M06,S06 and R06.
How do I write my where clause?? Help
FROM tblLeaveBalance_Cashables1
WHERE (((([Vacation]>640) or ([Annual Leave]>640)) And ([Personal Holiday (Hours)]>24)) AND ([tblLeaveBalance_Cashables1].[CBID]) In ("M06") and ("S06") and ("R06")
I need to extract data that where vacation time is >640 or annual leave is >640 and where personal Hol hours are >24 and CBID is M06,S06 and R06.
How do I write my where clause?? Help