SubTotal Question

[Guest]

I am working on a report that is organized by a clients unique ID number. It
prints out the ID number as a heading, then each of the client's transactions
below that, then it goes to the next client's information. What I'm hoping
to do is to print a total for each client showing exactly how much they have
spent with us. Right now, my report looks like this...

Client ID
Client Name Client Transaction1 Transaction $ Amount
Client Name Client Transaction2 Transaction $ Amount
Client Name Client Transaction3 Transaction $ Amount
Client ID 2
Client Name2 Client Transaction1 Transaction $ Amount
Client Name2 Client Transaction2 Transaction $ Amount
Client Name2 Client Transaction3 Transaction $ Amount
Client Name2 Client Transaction4 Transaction $ Amount

and so on. I simply cannot figure out how to print the Total Transaction $
Amount for each person. Any help would be greatly apprecitated. I'm working
with Access 97. Thanks

 

[Duane Hookom]

You can add a text box to either the ClientID header or footer section and
set the control source to:
=Sum([TransactionAmountField])