Newbie Needs help with combine/average

[wfd1753]

I am sure that I am just trying to make this more difficult than it is but I need some help. I am very new to access and setting it up for my company. I have a customer data base with the following fields:
Job ID
Customer ID
Job Description
Quote
What I want to do is to combine all of the duplicate Customer ID's and then get an average of the quote. I have used the query and thought I had it but I don't it is not combining the matching Customer ID's they are still listed out individually. It did add the field: count of jobs which would be used to get the average once the matching records are combined.



I have got another Query to do after I sort this one out. I want to be able to determine the deposit that each customer would owe me if they accept the quote. It would use the same fields but then give me what the 20% deposit would be.

Thanks in advance for the help!! It is greatly appreciated!!!

[jya]

For the first query, I imagine that you are looking to do a 'Total' query where you select 'Group By' based on Customer ID and 'Avg' for Quote.

I am not sure I completely understand what you are looking for in your second query. I am guessing that you want to create an expression field.

ex.

Deposit: 0.20 * [Quote]

Hope this helps.

[narayanis]

your query would look something like this:

select customerid, avg(quote)
from table
group by customerid