I created this query that filters based on a variable that I set with code. However it would not filter by Whse Like I want. Now I am hard coding in Warehouse numbers and it still isn't filtering by Warehouse. What is wrong:

SELECT Scheduled_Appts.Appt_Date, Scheduled_Appts.Sch_Time, Scheduled_Appts.Arr_Time, Scheduled_Appts.Missing_PaperWork, Scheduled_Appts.Incoming, Scheduled_Appts.Appt_ID, Scheduled_Appts.Outgoing, Scheduled_Appts.Dep_Time, Scheduled_Appts.Created_by, Scheduled_Appts.Created_Date, Scheduled_Appts.Last_Modified_by, Scheduled_Appts.Last_Modified_Date, Scheduled_Appts.Confirmation_Num, Scheduled_Appts.Arr_Date, tblWhse.Whse, Scheduled_Appts.Car_ID
FROM Scheduled_Appts LEFT JOIN tblWhse ON Scheduled_Appts.WhseID = tblWhse.whseID
WHERE (((Scheduled_Appts.Appt_Date)=[Forms]![frmScheduled_Appts]![cldrApptDates]) AND ((Scheduled_Appts.Incoming)=[Forms]![frmScheduled_Appts]![cbViewRec]) AND ((Scheduled_Appts.whseID)="2")) OR (((Scheduled_Appts.Appt_Date)=[Forms]![frmScheduled_Appts]![cldrApptDates]) AND ((Scheduled_Appts.Outgoing)=[Forms]![frmScheduled_Appts]![cbViewShip]))
ORDER BY Scheduled_Appts.Sch_Time, Scheduled_Appts.Arr_Time;

I figured out one issue but now I have another issue with the Variable. Here is the Variable that I set:

strWhse = "01, 02, Demed"

Then I use a function to get it and put it in the Query. However, that is supposed to be strWhse = "01" or "02" or "Demed". How do I get or's in the variable?

Does anybody know how I can do this?