Totals query

[circles]

I have a table that has five years of data in it. What I would like to do is build an update query that will by year and customer id total orders placed and total Dollar amount placed and then with this information determine avg dollar amount per order.

Thanks for your help

 

[CFields]

MonthYear: CStr(Year([Work Day]) & CStr(Month([Work Day]))) something like this or use datepart. In order to use the report wizard to total and average make it 2 fields and number on table. You can't total text fields by the wizard.
Also if your using access they have an order database that you can append your data to and use or get samples from. Good luck

 

[circles]

CFields Thanks for your help