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?