Returning 2 Values Based On 1 Maximum Value, Access 2010

[vland]

I have one table which stores the following information: [DateTime], [Flow] (number), and [Chemical Concentration] (number).



I need to find the maximum hourly flow for the day which is a no brainer. I group on "YYMMDDHH" and set the query result to MAX. My problem is this, at the maximum flow for the hour, I also have to record the Chemical Concentration. If I try and do this in the same query, the only choices I have are Max, Min, First, Last, etc. for the Chemical Concentration. I've tried concatenation followed by sorting but I'm getting nowhere.

Any thoughts would be welcome.

Vern

[JoeM]

You can do this using a series of two queries.
First, create the Aggregate query like you have that returns the Max value you are looking for.
Then create a new query, linking this Aggregate Query back to the Original table on whatever ID field you have (if any) AND the Flow field.
Then return any fields you want.

[vland]

I appreciate the help.