Newbie needs help with average/deposit query! Help!!

[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!!!

 

[dhookom]

I believe the SQL view of your query would look something like:

SELECT [Customer ID], Count([Job ID]) as JobCount,
  Avg([Quote]) as QuoteAvg
FROM [Some table]
GROUP BY [Customer ID];

Duane
Hook'D on Access
MS Access MVP