Most Recently Entered Records

[Guest]

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.

 

[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.

 

[Guest]

Thanks for your help.

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>