Calculate average from specific records

[faythe1215]

I have a table with a list of items and their prices, some items are listed more than once. I would like to create a query that stores each item only once with the average price for that item.

Is this possible in a query? I know that it can be done in a report, but I will need to access that data repeatedly.

[June7]

That would be an aggregate (GROUP BY) Totals query object.

[faythe1215]

Thanks!