easiest way to make query?

#1

Is there an easy way to make a query that adds up invoices for
customers?

I have a table that has a customers # and an balance...

such as

1234 $20.00
4444 $30.00
1234 $10.00
5555 $25.00
1234 $5.00

the query would show

1234 $35.00
4444 $30.00
5555 $25.00

Thanks for any help
Scott

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

easiest way to make query?

comp.databases.ms-access comp.databases.ms-access

easiest way to make query? - 08-05-2003 , 06:01 PM