Most recent date

  • Thread starter Thread starter ckornoelje
  • Start date Start date
C

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.
 
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.
Click to expand...

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.
 
Steve said:
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".
Click to expand...

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
 
Interesting rebuttal, but do you really mean to call yourself a stupid jerk?

John... Visio MVP
 
Back
Top