Query Min Max function

[dpjoest]

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

 

[Jeff Boyce]

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>

 

[dpjoest]

Jeff,

Thanks that was very helpful. I greatly appreciate your response

 

[dpjoest]

Jeff,

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>