I tried to remove obvious confidential field names but this is a sample of what I am talking about:
Code:
SELECT qryUNS.UNSid, tblTax.custid, tblTax.St, tblTax.grosswgs, tblTax.taxablewgs, IIf([grosswgs]/[taxablewgs]>0,0,[grosswgs]/[taxablewgs]) AS adjusttax., IIf([qrytax1].[rte] Is Null,[qrytax1].[revn],[qrytax1].[Nondisp_rate]) AS disp, IIf([qrytax2].[nte] Is Null,[qrytax2.[nontx],[qrytax2].[cost]) AS nondisp, IIf([cin]>0,"audit",IIf([max] Is Null,"noaudit","minaudit")) AS aud, IIf([num]>0,”N”,”Y”) AS audn, IIf([qryPermissions.cust_id] Is Null,"Y","N") AS granted, qrycust.custid, tblchg.stat, qryWgsN.[sDisp], qryGgsS.bDip
FROM ((((((((((tblTax LEFT JOIN qrytax1 ON (tblTax.custid = qrytax1.id) AND (tblTax.Sid = qrytax1.Sid)) LEFT JOIN qrytax2 ON (tblTax.Sid = qrytax1.[Sid]) AND (qrytax2.id = qrydisWgs.cust)) LEFT JOIN qryTblchg ON (tblTax.ID= qryTblchg.ID) AND (tblTax. id = qryTblchg. id)) LEFT JOIN qryPermissions ON (tblTax.St = qryPermissions.cust_id) AND (tblTax.id = qryPermissions.cust_id)) LEFT JOIN qryWrates ON (qryPermissions.cust_id= qryWrates.[id] AND (qryPermissions.cust_id = qryWrates.ID)) LEFT JOIN qryGrnts ON (tblTax.ID = qryGrnts.ID) AND (tblTax.cust_id = qryGrnts.id)) LEFT JOIN qrydisWgs ON (tblTax.ID = qrydisWgs.[disP]) AND (tblTax.id = qryWgs. id)) LEFT JOIN qryGgss ON tblTax.id = qryaud.id) LEFT JOIN qryUNS ON (tblTax.id = qryUNS.sid) AND (tblTax.id = qryUNS.id)) LEFT JOIN tblDt ON tblTax.id = tblID.cid) LEFT JOIN tblAud ON tblID.num = tbldis.num
WHERE (((qrytax2. disp) is not null));