Most recent date

[ckornoelje]

What is the command in a query to look at my table and pick the most recent
date. I know current date is Date()...I can even say /Date()-30 or so. I
just want it to look at the most recent.

 

[John W. Vinson]

What is the command in a query to look at my table and pick the most recent
date. I know current date is Date()...I can even say /Date()-30 or so. I
just want it to look at the most recent.

If you just want to see the most recent record in the table, put "Ascending"
on the Sort property of the date field and set the Query's Top Values property
to 1.

 

[Larry Linson]

Change your query to a totals query. Click on
the Sigma button (looks like a capital E) in the
menu at the top of the screen. Under your date
field, change "Group By" to "Max".

Jumping to conclusions again? This time about the original poster ONLY
wanting the date, are you, Steve? And didn't think it even worth asking if
he/she really wanted the data associated with the most recent date?

Larry

 

[John... Visio MVP]

Interesting rebuttal, but do you really mean to call yourself a stupid jerk?

John... Visio MVP