How do I get the most recent occurance of a vaule or date in an A.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get the most recent occurance of a value and or a date. I have
a vaule in a field (i.e. 123456, 23456, 34567) I need 34567 to appear since
it is the greater value. I also need to kow how to get the most recent date
when multiple dates occur. (i.e. 10/12/04, 10/01/04, 09/25/04) I need
10/12/04 to appear since it is the most recent date. Thank you in advance for
your assistance!
 
Try:

SELECT MAX(YourField) AS YourFieldName
FROM YourTable

That won't tell the most "recent" value, but it will give you the highest
order value in the field, which I think is what you're asking?


Jamie
 
Back
Top