average price

[Rpettis31]

I am importing a table and I am trying to query the average price for an
item, the issue is the items have been sold to a variety of customers and at
various prices.
I am trying to get a list of items and the average price and I am not sure
how I would go about doing this.

 

[Ken Snell [MVP]]

You want a totals query that is grouped on item and that gives the average
of the price field.

The query wizard will help you set this up. Post back if you have questions.