Returning the miniumum of several fields

  • Thread starter Thread starter Lexie
  • Start date Start date
L

Lexie

I have a table that contains a row for each product and a
column for that product's sales each week. I'm trying to
create a query that will return the minimum sales for each
product. It seems the only thing Access can do is return
the minimum sales for each week. Help!?
 
If you create a totals query using the product's name and sales; setting the
product to GroupBy and Sales field to MIN, this should give you the minimum
sale overall for the product. Do not add any other fields to the query. If
you do, it may throw off your results.
 
Back
Top