average price

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

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.
 
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.
 
Back
Top