Totals on change

Giganews Newsgroups
Subject: Totals on change
Posted by:  brm6546545 (russell.allbrita…@gmail.com)
Date: 25 Aug 2006

I have a tblTax. It has fields InvoiceNum, TaxAuthority, TaxableTotal,
NonTaxableTotal, TaxCollected.

Sample data

1,county,10.00,0.00,0.40
1,city,10.00,0.00,0.10
2,state,0.00,15.00,0.15

When totaling invoice 1 should have totals of 10.00,0.00,0.50 because
the 10.00 is the total for the invoice, but 0.50 is the total tax
collected. I nee these totals in a report. In crystal reports i could
just do a total on change of invoice number for the Taxable and
nonTaxable Totals. but i have to this on an Access adp. I was hoping i
could get a query to return something like

inv,auth,Taxable,nonTaxable,Collected,TaxableTot,NonTaxableTot,CollectedTot
1,county,10.00,0.00,0.40,10.00,0.00,0.50
1,city,10.00,0.00,0.10,10.00,0.00,0.50
2,state,0.00,15.00,0.15,0.00,15.00,0.15

I'm not sure how to do a group by that would allow this, although im
sure its possible.

Replies