Here is the query SQL as formatted by PoorSQL for clarity.
Code:
SELECT Cons.Import_ID
,[_CategoryDescriptionLookup].Description
,[_BrandLookup].Brand_Name
,[_supplierLookup].SuppName
,Cons.BigQty
,Cons.SmallQty
,Cons.BankValue
,Cons.ActuValue
,[_cnfLookup].CNF_Name
,Cons.FK_SupplierID
FROM _cnfLookup
INNER JOIN (
_CategoryDescriptionLookup INNER JOIN (
_supplierLookup INNER JOIN (
Cons INNER JOIN _BrandLookup ON Cons.[FK_BrandID] = [_BrandLookup].Brand_ID
) ON ([_supplierLookup].Supp_ID = Cons.FK_SupplierID)
AND ([_supplierLookup].Supp_ID = Cons.FK_SupplierID)
) ON [_CategoryDescriptionLookup].Catg_ID = [_BrandLookup].FK_CategoryID
) ON [_cnfLookup].CNF_ID = Cons.FK_CNFID
WHERE (
(
(Cons.Import_ID) LIKE "*" & [Forms] ! [Cons Filter] ! [cboFiscalYear] & "*"
AND (Cons.Import_ID) LIKE "*" & [Forms] ! [Cons Filter] ! [cboStation] & "*"
AND (Cons.Import_ID) LIKE "*" & [Forms] ! [Cons Filter] ! [cboCatagory] & "*"
)
AND (([_CategoryDescriptionLookup].Description) LIKE "*" & [Forms] ! [Cons Filter] ! [cboDes] & "*")
AND (
(Cons.BankValue) BETWEEN [Forms] ! [Cons Filter] ! [txtBank1]
AND [Forms] ! [Cons Filter] ! [txtBank2]
)
AND ((Cons.FK_SupplierID) = [Forms] ! [Cons Filter] ! [cboSupplierID])
AND ((Cons.FK_BrandID) = [Forms] ! [Cons Filter] ! [cboBrandID])
)
OR (
(
(Cons.Import_ID) LIKE "*" & [Forms] ! [Cons Filter] ! [cboFiscalYear] & "*"
AND (Cons.Import_ID) LIKE "*" & [Forms] ! [Cons Filter] ! [cboStation] & "*"
AND (Cons.Import_ID) LIKE "*" & [Forms] ! [Cons Filter] ! [cboCatagory] & "*"
)
AND (([_CategoryDescriptionLookup].Description) LIKE "*" & [Forms] ! [Cons Filter] ! [cboDes] & "*")
AND (
(Cons.BankValue) BETWEEN [Forms] ! [Cons Filter] ! [txtBank1]
AND [Forms] ! [Cons Filter] ! [txtBank2]
)
AND (([Forms] ! [Cons Filter] ! [cboBrandID]) IS NULL)
);