Incorrect summation in report footer

[wizard_chef]

From a semi-newbie: I have a query run on a typical customer database where on a given date, a customer may make more than one purchase. I also record the payment amount.

When I create the report, with the report bound that that query, and try to sum the payments in the footer, I get an incorrect sum for the total payments over a period. The reason is because the query produces a payment entry for each transaction on a given date. So, if a customer has more than one purchase on a given date, the payment amount appears multiple times and appears in the summation.

What is the easiest solution to this problem (I have tried a couple and so far nothing works)?

[Graysworld]

I have this exact same problem. Did you find a solution?
I posted my question at:
http://www.utteraccess.com/forums/sh...b=5&o=&fpart=1

[Graysworld]

if a customer has more than one purchase on a given date, the payment amount appears multiple times and appears in the summation.

Ok, I've found the solution to my problem and yours; I'm supprised no-one has attempted to offer to solve this yet, as it seems something that would come up every now and then.

Find the solution at Microsoft.

I posted my problem on www.UtterAccess.com at
http://www.utteraccess.com/forums/sh...b=5&o=&fpart=1