Min Value Query

[MLT]

I have a table in Access with 3 columns: ID number, Time of
Measurement, Measurement Value. I want to find the minimum
Measurement Value, which I think is pretty easy by just doing a query
using Group By for ID number and Min for Measurement Value. But where
I am struggling is I also want to know the Time of Measurement
associated with that Min Value. If I add that to the query as Group
By then it seems to just disregard the Min for Measurement Value and
returns all Measurement Values.

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article suggests using a subquery. If that's a new concept, here's an
introduction:
http://allenbrowne.com/subquery-01.html