calculated field

[amavadia]

I have a table with customers, one with products and one transaction table. How can i produce a report, based on a query that will add up the total any one particular customer has spent to date from the transaction table?

 

[Rich]

Use a Totals Query, GroupBy customer Sum amount