> Kenneth Gustav Eitenmiller Jr wrote:
> >
> > Dale,
> > I am getting this:
>
> 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.amount
tax2)
> > 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
It seems to work if I take the "amount" from infront of half of the field
names.
Now I have to figure out why I have a bunch of (null) taxid's
Thanks,
Ken
>
>
> --
>
> 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
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart