Query Min Max function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with an Item# field and a cost field.

For any given Item# there could several records with different costs.

How do I export or build a table that would extract only the lowest cost for
any one Item#.
Thanks.

Doug
 
Doug

Don't use a table. Use a query. Check on "Totals" queries in Access HELP.
If you open a new query in design mode, select Item# and Cost fields, then
click the "sigma" toolbar button, Access changes the query to a Totals
query, using "GroupBy" for both fields. Change that to Minimum for the Cost
field, leaving the "GroupBy" for the Item# field.

Regards

Jeff Boyce
<Office/Access MVP>
 
Jeff,

Thanks,

Doug

Jeff Boyce said:
Doug

Don't use a table. Use a query. Check on "Totals" queries in Access HELP.
If you open a new query in design mode, select Item# and Cost fields, then
click the "sigma" toolbar button, Access changes the query to a Totals
query, using "GroupBy" for both fields. Change that to Minimum for the Cost
field, leaving the "GroupBy" for the Item# field.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top