MAX Date Records, But No Duplicates

[Only4Access]

Hello Forum,

Thank you for all the support have been provided from everyone. Now i am stuck on the SELECT query to return MAX record.

I have been playing with this article to return MAX date record with all record from original table



http://www.techonthenet.com/access/q...uery2_2007.php

The problem is, If i have a record with more than one same MAX date, it displays that records n times.

Please see the attached sample DB. If you run qryMAxDetails, you can see Text2 is duplicated with 1/2/2015 1:30:00 AM. I only want to return one time, REGARDLESS of other fields. As you can see in the query criteria set to AccID=1 with MAX date. I only want to return one record for Text2. EmpID or SiteID is don't matter. If we can display Record 2 or 3 no problem.

I hope you all understand my issue. thank you for your valuable time.

[rpeare]

you have to run two consecutive 'max' queries to get what you want, in this case I took the max ID (most recent record).

See here:
Sample.zip

[Only4Access]

wowwwww. Thank you rpeare. Works like a charm! I should have been learn more about Group in queries

Thanks a lot rpeare Thanks a lot.