SELECT Input.Enquiry_Index, Input.Enquiry_Number, Input.Project_Name, Client_Info.Client_Name, Input.Date_Received,
Input.Quote_Due_Date, tblEnqMan.[Enquiry Manager] AS [Enq Man], Input.Quote_Date,
Input.Value, Input.Job_Number, Input.Project_Detail, Input.kw, Input.Enquiry_Manager,
tblEnqMan.EnqManLstNm, tblEnqMan.EnqManFrstNm, tblEnqTyp.[Enquiry Type], tblIndSec.[Industry Sector],
Input.[Client's_Internal_Reference], tblJobTyp.[Job Type], Input.ProgDates, Input.Comment,
Input.Follow_up_Date, Input.ServerDir, Input.FlwUpRsp, tblEnqStg.EnqStg, tblEnqrr.Enquirer,
tblMedium.Medium, tblPEquipDir.PEquipDir, [Contact_Name] & ", " & [Contact_First_Name] AS Contact,
Input.Enquiry_Type AS EnqTypID, Input.Industry_Sector AS IndSecID, Input.Job_Type AS JobTypID,
Input.EnqStg AS EnqStgID, Input.Enquirer AS EnqrrID, Input.Medium AS MedID, Input.PEquipDir AS PEDID,
Input.CreditLimit, Input.JbNoSfx, Input.fkEnqReasonID
FROM tblPEquipDir RIGHT JOIN (tblMedium RIGHT JOIN (tblJobTyp RIGHT JOIN (tblIndSec RIGHT JOIN (tblEnqStg RIGHT JOIN
(tblEnqrr RIGHT JOIN ((Client_Info RIGHT JOIN Contact_Info ON Client_Info.Client_ID = Contact_Info.Client_FK) RIGHT JOIN
((tblEnqMan AS tblEnqMan_2 RIGHT JOIN (tblEnqMan AS tblEnqMan_1 RIGHT JOIN (tblEnqMan RIGHT JOIN (tblKw RIGHT JOIN
(tblEnqTyp RIGHT JOIN [Input] ON tblEnqTyp.EnqTypID = Input.Enquiry_Type) ON tblKw.KwID = Input.kw)
ON tblEnqMan.EnqManID = Input.Enquiry_Manager) ON tblEnqMan_1.EnqManID = Input.PrjEng) ON
tblEnqMan_2.EnqManID = Input.ContRev) LEFT JOIN tblCompLnk ON Input.Enquiry_Index = tblCompLnk.Enquiry_FK)
ON Contact_Info.Contact_ID = tblCompLnk.Cntct_FK) ON tblEnqrr.EnqrrID = Input.Enquirer) ON
tblEnqStg.EnqStgID = Input.EnqStg) ON tblIndSec.IndSecID = Input.Industry_Sector) ON
tblJobTyp.JobTypID = Input.Job_Type) ON tblMedium.MedID = Input.Medium) ON
tblPEquipDir.PEquipID = Input.PEquipDir
WHERE (((Input.Enquiry_Number) Like "*" & fCboSrch([Forms].[frmebsrch]![txtENoSrch]) & "*" Or
(Input.Enquiry_Number) Is Null) AND ((Input.Project_Name) Like "*" & fCboSrch([forms].[frmebsrch].[form]![txtPrjNmSrch]) & "*"
Or (Input.Project_Name) Is Null) AND ((Client_Info.Client_Name) Like "*" & fCboSrch([forms].[frmebsrch].[form]![txtClntNmSrch]) & "*"
Or (Client_Info.Client_Name) Is Null) AND ((Input.Date_Received) Between fDtSrchL([Forms]![frmebsrch]![txtDtFrmSrch]) And fDtSrchU([Forms]![frmebsrch]![txtDtToSrch])
Or (Input.Date_Received) Is Null) AND ((Input.Value) Between fValSrchL([Forms]![frmebsrch]![txtPrcLowSrch]) And fValSrchU([Forms]![frmebsrch]![txtPrcUpSrch])
Or (Input.Value) Is Null) AND ((Input.Project_Detail) Like "*" & fCboSrch([forms].[frmebsrch].[form]![txtPrjDetSrch]) & "*"
Or (Input.Project_Detail) Is Null) AND ((Input.kw) Between fkwsrchl([Forms]![frmebsrch]![cbokwSrch]) And fkwsrchu([Forms]![frmebsrch]![cbokwSrch])
Or (Input.kw) Is Null) AND ((tblEnqStg.EnqStg) Like "*" & fCboSrch([forms].[frmebsrch].[form]![cmbEnquiryStage]) & "*") AND (([Contact_Name] & ", " & [Contact_First_Name]) Like "*" & fCboSrch([forms].[frmebsrch].[form]![txtCntctNmSrch]) & "*") AND ((Input.Enquiry_Type) Like [Forms]![frmebsrch]![cboEnqTypSrch] & "*"
Or (Input.Enquiry_Type) Is Null) AND ((Input.Industry_Sector) Like [Forms].[frmebsrch]![cboIndSecSrch] & "*"
Or (Input.Industry_Sector) Is Null) AND ((Input.Job_Type) Like [Forms].[frmebsrch]![cboJobTypSrch] & "*"
Or (Input.Job_Type) Is Null) AND ((Input.EnqStg)=IIf([Forms]![frmebsrch]![optCrntEB],0)
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optCrntEB],1)
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optCrntEB],2) 
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optCrntEB],3)
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optCrntEB],4)
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optCrntEB],5)
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optCrntEB],6)
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optOrdrEB],7)
Or (Input.EnqStg)=IIf([Forms]![frmebsrch]![optHistEB],8)
Or (Input.EnqStg) Is Null) AND ((Input.Enquirer) Like [Forms].[frmebsrch]![cboEnqrrSrch] & "*"
Or (Input.Enquirer) Is Null) AND ((Input.Medium) Like [Forms].[frmebsrch]![cboMedSrch] & "*"
Or (Input.Medium) Is Null) AND ((Input.PEquipDir) Like [Forms]![frmebsrch]![cboPEquipSrch] & "*"
Or (Input.PEquipDir) Is Null) AND ((Input.fkEnqReasonID) Like "*" & fCboSrch([forms].[frmebsrch].[form]![cmbReason]) & "*"
Or (Input.fkEnqReasonID) Is Null) AND ((Client_Info.Client_Address) Like "*" & fCboSrch([forms].[frmebsrch].[form]![txtAddSrch]) & "*"
Or (Client_Info.Client_Address) Is Null))
ORDER BY Input.Enquiry_Number DESC;