SELECT tblEstimateItems.EstimateID, tblEstimateItems.EstimateItemID,
    CDbl(Choose([itemtype],nz(tblestimates.PDDiscount,0),nz(tblestimates.DPDiscount,0),nz(tblestimates.FFDiscoun
    t,0),nz(tblestimates.PRDiscount,0),nz(tblestimates.U1Discount,0),nz(tblestimates.U2Discount,0))) AS Discount,
    IIf(nz(tblCustomers.taxable,0)=0,0,IIf(nz(tblestimateitems.taxable,0)=0,0,-1)) AS IsItemTaxable,
    nz([UnitPrice],0)-
    (nz([UnitPrice],0)*nz(CDbl(Choose([itemtype],nz([tblestimates].[PDDiscount],0),nz([tblestimates].[DPDiscount],0
    ),nz([tblestimates].[FFDiscount],0),nz([tblestimates].[PRDiscount],0),nz([tblestimates].[U1Discount],0),nz([tbles
    timates].[U2Discount],0))),0)) AS DiscountPrice, tblEstimateItems.UnitPrice, tblEstimateItems.Quantity,
    round_tsb(Nz([Quantity])*(nz([UnitPrice],0)-
    (nz([UnitPrice],0)*nz(CDbl(Choose([itemtype],nz([tblestimates].[PDDiscount],0),nz([tblestimates].[DPDiscount],0
    ),nz([tblestimates].[FFDiscount],0),nz([tblestimates].[PRDiscount],0),nz([tblestimates].[U1Discount],0),nz([tbles
    timates].[U2Discount],0))),0))),2) AS DiscountExtPrice,
    IIf([IsItemTaxable]=0,0,round_tsb(nz(SUM([Amount]),0),2))-
    (IIf([IsItemTaxable]=0,0,round_tsb(nz(SUM([Amount]),0),2))*(nz(CDbl(Choose([itemtype],nz([tblestimates].[PD
    Discount],0),nz([tblestimates].[DPDiscount],0),nz([tblestimates].[FFDiscount],0),nz([tblestimates].[PRDiscount],
    0),nz([tblestimates].[U1Discount],0),nz([tblestimates].[U2Discount],0))),0))) AS TaxAmtDisc
    FROM (tblEstimates LEFT JOIN tblCustomers ON tblEstimates.CustomerID = tblCustomers.CustomerID) LEFT
     JOIN (tblEstimateItems LEFT JOIN tblEstimateItemTaxes ON tblEstimateItems.EstimateItemID =
    tblEstimateItemTaxes.EstimateItemID) ON tblEstimates.EstimateID = tblEstimateItems.EstimateID
    GROUP BY tblEstimateItems.EstimateID, tblEstimateItems.EstimateItemID,
    CDbl(Choose([itemtype],nz(tblestimates.PDDiscount,0),nz(tblestimates.DPDiscount,0),nz(tblestimates.FFDiscoun
    t,0),nz(tblestimates.PRDiscount,0),nz(tblestimates.U1Discount,0),nz(tblestimates.U2Discount,0))),
    IIf(nz(tblCustomers.taxable,0)=0,0,IIf(nz(tblestimateitems.taxable,0)=0,0,-1)), nz([UnitPrice],0)-
    (nz([UnitPrice],0)*nz(CDbl(Choose([itemtype],nz([tblestimates].[PDDiscount],0),nz([tblestimates].[DPDiscount],0
    ),nz([tblestimates].[FFDiscount],0),nz([tblestimates].[PRDiscount],0),nz([tblestimates].[U1Discount],0),nz([tbles
    timates].[U2Discount],0))),0)), tblEstimateItems.UnitPrice, tblEstimateItems.Quantity,
    round_tsb(Nz([Quantity])*(nz([UnitPrice],0)-
    (nz([UnitPrice],0)*nz(CDbl(Choose([itemtype],nz([tblestimates].[PDDiscount],0),nz([tblestimates].[DPDiscount],0
    ),nz([tblestimates].[FFDiscount],0),nz([tblestimates].[PRDiscount],0),nz([tblestimates].[U1Discount],0),nz([tbles
    timates].[U2Discount],0))),0))),2)
    HAVING (((tblEstimateItems.EstimateID) IS NOT NULL));