Ok. Let me actually look at this. :( I'm a little under the
weather today...
> Select ii.TaxID, beforetax=sum(ii.amount*ii.quantity), taxes=sum(ii.tax)+sum(ii.tax2),
> total=sum(ii.amount*ii.quantity)+sum(ii.tax)+sum(ii.tax2)
> From Invoices i, InvoiveItems ii
> Where i.InvoiceID = ii.InvoiceID
> and i.Type <> "VOID"
> and i.Date between @begindate and @enddate
> Group By ii.TaxID
> Order By ii.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