469,325 Members | 1,596 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,325 developers. It's quick & easy.

most recent date

I have a collumn filled with dates. How would I go about selecting the record with the most recent date.
using access 2000.
thanks!
Nov 13 '05 #1
3 2169
On Tue, 17 Aug 2004 13:34:05 GMT, <jj****@earthlink.net> wrote:
I have a collumn filled with dates. How would I go about selecting the record with the most recent date.
using access 2000.
thanks!


Where? In a Query?
Where [DateField] = DMax("[DateField]","TableName")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2
jj****@earthlink.net wrote:
I have a collumn filled with dates. How would I go about selecting the record with the most recent date.
using access 2000.
thanks!


Select top 1 * from table order by datefield;
Nov 13 '05 #3
Trevor Best wrote:
jj****@earthlink.net wrote:
I have a collumn filled with dates. How would I go about selecting the
record with the most recent date.
using access 2000.
thanks!

Select top 1 * from table order by datefield;


Sorry, "order by Datefield DESC;"

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Nova's Taylor | last post: by
3 posts views Thread by TJM | last post: by
6 posts views Thread by HandersonVA | last post: by
4 posts views Thread by doublej0 | last post: by
4 posts views Thread by Lee | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.