Query that Generates only the Last Records Entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access Table that will be updated often. I can put the Timestamp on
the records but what I need to know is how to Query only the last records
entered from say today's date. What is the syntex or statement to only give
me these records.

Thanks
 
SELECT * FROM TableName
WHERE [TimestampField] =
(SELECT Max(T.[TimestampField])
FROM TableName AS T
WHERE T.PrimaryKeyField = TableName.PrimaryKeyField);
 
Back
Top