query that sums the data for me

[citygov]

I need to write a query that takes basic address info and combines it with a customer's total due. The customer address table is all set, and the key for both tables is linked fine, but the financial table I need the total from can have multiple lines of current amount due for each customer. Is it possible to have the query automatically sum up the total in the "amounts" field for each customer number? The only other option I can think of is to dump the financial into excel, manually total each customer's total due, and use that figure in the amount field. Any help is appreciated - thanks!
Mike

[pbaldy]

Sure; you want a totals query. Start with a basic query, then click on the big Greek "E" on the ribbon that says totals. You'd want Sum in the amount columns in the new row you'll see.

[citygov]

Oh my gosh, I never even looked at that. I'm so used to simple, quick queries that I never looked any deeper! Thanks!

[pbaldy]

No problem! Totals queries are a valuable tool.

[pbaldy]

Welcome to the site by the way!