Sorry. Lets try this:
> Select ii.TaxID, beforetax=sum(ii.amount*ii.amountquantity), taxes=sum(ii.amounttax)+sum(ii.amounttax2),
> total=sum(ii.amountamount*ii.amountquantity)+sum(ii.amounttax)+sum(ii.amounttax2)
> From Invoices i, InvoiveItems ii
> Where i.InvoiceID = ii.InvoiceID
> and i.Type <> "VOID"
> and i.Date between @begindate and @enddate
> Group By TaxID
> Order By TaxID
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart