Most Recently Entered Records

D

dbenjes

I have a table that is updated often during various times of the month. I can
set a time stamp on the records when they are entered but how do I only get
the most recent records entered using a Query? I know there must be a
conditionally statement that would only give me the most recent records from
a specific date(say today).

Thanks for any help you can provide.
 
J

Jeff Boyce

If you open a query in design mode, you can set the sort order to Descending
for the field holding your timestamp. If you add a criterion under that
same field, you can limit to a particular day or range of dates.

NOTE: if your timestamp has both date AND time, you'll need to use a
criterion that has both date and time... or you can convert your timestamp
to a date-only in your query and compare to only a date.
 
D

dbenjes

Thanks for your help.

Jeff Boyce said:
If you open a query in design mode, you can set the sort order to Descending
for the field holding your timestamp. If you add a criterion under that
same field, you can limit to a particular day or range of dates.

NOTE: if your timestamp has both date AND time, you'll need to use a
criterion that has both date and time... or you can convert your timestamp
to a date-only in your query and compare to only a date.

--
Good luck

Jeff Boyce
<Access MVP>
Click to expand...
 
Top