Sum All my charges

[The Red Star]

I have a report which i need to display one record for each customer (even when they have made multiple entries) which has a sum of the amount they owe.

eg, if a person orders a pair of boots one week, it goes down in the charges as a new charge, then if they order a jacket, that goes down as a new charge. I need a report which shows how much in total (for boots and jacket) they owe.

 

[simongallop]

In design view, right click top left and select Sortin and Grouping. Choose the customer to group on and select header and footer. Now place a testbox in the customer_Footer and make that the sum.

HTH

 

[The Red Star]

The query option sounds the best way to go about it, so i designed a new query, but i don't know how to sum the charges. I used the sum function (in the total row), but it made no difference. It still displayed all the different charges.
Any ideas?
If this explaination doesn't help i can email the query to anyone interested.

P.s. the reason i chose the query route was because the footer (therefore charge total) needs to be lower than the name line, wheras i have a set format which restricts me to them both being on the same line