GET SINGLE ROW ORDER BY LATEST DATE.

[Sinner]

Hi,


In below query I want to return the DAT.MS by latest date.


SELECT DAT.[Date_Time], DAT.MS, DAT.Activity, DAT.User, DAT.[Business
Partner], DAT.Region, DAT.[Receipt No], DAT.[Payment Amount],
DAT.SCARD_NO, DAT.SI_NO
FROM DAT
WHERE (((DAT.Activity) Like "*REGULAR*") AND ((DAT.SI_NO)<>"NA"));


The field has same value against different dates like:


DATE_TIME MS (REST OF THE FIELDS)
21/08/2008 78
16/08/2008 78
22/08/2008 78
13/08/2008 78


The result that I need is below so that there is no other entry (no
duplicate rows)
22/08/2008 78

 

[Allen Browne]

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

The article gives 4 solutions.