SELECT Reservations.[CR#_], Reservations.[Requestor Rank and Name], Reservations.Tell_No_, Reservations.Driver, Reservations.[Reporting Point], Reservations.Destination, Reservations.Purpose, Reservations.[No_of PAX], Reservations.[Date Required], Reservations.[Time Required], Reservations.[Date of Return], Reservations.[Time of Return], Reservations.Remarks, Reservations.RtnOdmtrMls, Reservations.Attachments, Reservations.Attachments.FileData, [Attachments].[FileFlags] AS Expr1, Reservations.Attachments.FileName, [Attachments].[FileTimeStamp] AS Expr2, Reservations.Attachments.FileType, [Attachments].[FileURL] AS Expr3, Reservations.AuthMemochk, Reservations.AuthMemoTmStm, Reservations.AuthSigchk, Reservations.AuthSigTmStm, Reservations.PreChkInspchk, Reservations.PreChkInspTmStm, Reservations.VcoDispChk, Reservations.VcoDispTmStm, Reservations.PostChkInspchk, Reservations.PostChkInspTmStm, Reservations.VcoInChk, Reservations.VcoInTmStm, Reservations.RtnOdmtrMls, frmCRNumRowQuery.Model_, Reservations.RegNo, frmCRNumRowQuery.[Reg_#_], Reservations.TimeIn, Reservations.TimeOut, Reservations.[Res#], [Forms]![Reservations Query]![cboResQryFltr1] AS Expr4, Reservations.Charges
FROM qryCboResNum INNER JOIN (Reservations LEFT JOIN frmCRNumRowQuery ON Reservations.[CR#_] = frmCRNumRowQuery.[CR#_]) ON qryCboResNum.[CR#_] = Reservations.[CR#_]
WHERE ((([Forms]![Reservations Query]![cboResNum]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=False)) OR (((Reservations.[Res#])=[Forms]![Reservations Query]![cboResNum]) AND (([Forms]![Reservations Query]![cboResQryFltr1]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=False)) OR ((([Forms]![Reservations Query]![cboResQryFltr1]) Is Null) AND (([Forms]![Reservations Query]![cboResNum]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=False)) OR (((Reservations.[Res#])=[Forms]![Reservations Query]![cboResNum]) AND (([Forms]![Reservations Query]![cboResQryFltr1]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=False)) OR (((Reservations.[Date Required])>=[Forms]![Reservations Query]![txDteRq_]) AND ((Reservations.[Date of Return])<=[Forms]![Reservations Query]![txDteRtn_]) AND (([Forms]![Reservations Query]![cboResNum]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=True) AND ((frmCRNumRowQuery.[CR#_])=[Forms]![Reservations Query]![cboResQryFltr1])) OR (((Reservations.[Date Required])>=[Forms]![Reservations Query]![txDteRq_]) AND ((Reservations.[Date of Return])<=[Forms]![Reservations Query]![txDteRtn_]) AND (([Forms]![Reservations Query]![cboResNum]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=True) AND ((frmCRNumRowQuery.[CR#_])=[Forms]![Reservations Query]![cboResQryFltr1])) OR (((Reservations.[Date Required])>=[Forms]![Reservations Query]![txDteRq_]) AND ((Reservations.[Date of Return])<=[Forms]![Reservations Query]![txDteRtn_]) AND ((Reservations.[Res#])=[Forms]![Reservations Query]![cboResNum]) AND (([Forms]![Reservations Query]![cboResQryFltr1]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=True)) OR (((Reservations.[Date Required])>=[Forms]![Reservations Query]![txDteRq_]) AND ((Reservations.[Date of Return])<=[Forms]![Reservations Query]![txDteRtn_]) AND ((Reservations.[Res#])=[Forms]![Reservations Query]![cboResNum]) AND (([Forms]![Reservations Query]![cboResQryFltr1]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=True)) OR (((Reservations.[Date Required])>=[Forms]![Reservations Query]![txDteRq_]) AND ((Reservations.[Date of Return])<=[Forms]![Reservations Query]![txDteRtn_]) AND (([Forms]![Reservations Query]![cboResQryFltr1]) Is Null) AND (([Forms]![Reservations Query]![cboResNum]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=True)) OR (((Reservations.[Date Required])>=[Forms]![Reservations Query]![txDteRq_]) AND ((Reservations.[Date of Return])<=[Forms]![Reservations Query]![txDteRtn_]) AND (([Forms]![Reservations Query]![cboResQryFltr1]) Is Null) AND (([Forms]![Reservations Query]![cboResNum]) Is Null) AND (([Forms]![Reservations Query]![optBtnDteFltr])=True))
ORDER BY Reservations.[Date Required] DESC;