Query Totals

[John]

I have a query problem.
My query consists of account number, transaction code,
transaction description, and total charges.
I have a single account that have multiple transaction
codes where the total charges are the same for each
transaction code. This is supposed to be like this.
My problem is with the query and report.
On my report I have it designed just like I wanted; where
it doesn't show the same data more than once. The main
problem is with the grand total I have in the report
footer. It is taking the multiple total charges and
adding them also. I want to total what is just printed on
the report, not what is hiding too.
example:

acct # trans code description charges
123456 t5000 example descrip $1000.
t5001 example 2 $1000.
t5002 example 3 $1000.

Total: $3000.

The real total is only $1000, not $3000. I can't get it
to not count the multiple charges for the same account.

Please Help!

Thank you in advance!

John

 

[Lance]

So the total charges for multiple lines are stored
multiple times in individual line items? If thats not the
case please clarify. If that is the case then your design
is very flawed and you can expect to have these problems.