Or in Where SQL is not working. (1 Viewer)

[JimH]

For some reason I cant get the OR portion of this argument to work. The statement worked fine prior to adding the OR and all after. Thanks!

stSQLA65 = "SELECT tblDuty.Pilot, tblMembers.Lname, tblAircraft.AircraftType INTO tblDailyA65 FROM tblAircraft INNER JOIN (tblMembers INNER JOIN tblDuty ON tblMembers.Signal=tblDuty.Pilot) ON tblAircraft.AircraftTypeID=tblMembers.AircraftType WHERE (((tblAircraft.AircraftType)=" & """HH65""" & ")) And forms!frmDuty!date=tblDuty.date And [" & (Forms!frmDuty![txtDayField].Value) & "] = """ & A65 & """" & " OR (((tblAircraft.AircraftType)=" & """HH65""" & ")) And forms!frmDuty!date=tblDuty.date And [" & (Forms!frmDuty![txtDayField].Value) & "] = """ & AM & """" & ");"

 

[Jon K]

WHERE
(((tblAircraft.AircraftType)=" & """HH65""" & ")) And forms!frmDuty!date=tblDuty.date And [" & (Forms!frmDuty![txtDayField].Value) & "] = """ & A65 & """" & " OR
(((tblAircraft.AircraftType)=" & """HH65""" & ")) And forms!frmDuty!date=tblDuty.date And [" & (Forms!frmDuty![txtDayField].Value) & "] = """ & AM & """" & ");"


There is an extra ) in front of the ;
.