Problem with DAvg function

[averagejoe]

I'm relatively new to Access and have recently encountered a problem with the DAvg function.





Above is a table that should allow for better understanding.

So, what I needed to do was to calculate the average prices based on Vendor Codes. Hence, the DAvg function. I used this expression:

AL: DAvg("[Selling Price]","Item","[Vendor Code] = 'AL'")

Upon running the query, I obtain the correct value for the average, but the problem lies in that it returns me the value multiple times - 10 times, to be exact.



Could someone tell me why they return the result 10 times? Is there a problem with the expression; do I have to tweak something for it to work correctly; or am I using the wrong function to obtain the values I want?

[alansidman]

Here is a Query that returns the average selling price per vendor. It is called an aggregate query as it uses the aggregation function (the Sigma) in the QBE.

SELECT Table1.VendorCode, Avg(Table1.SellingPrice) AS AvgOfSellingPrice
FROM Table1
GROUP BY Table1.VendorCode;

Here is a short tutorial on aggregations

http://www.techonthenet.com/access/queries/index.php

Scroll down to the group by section

Alan