Discussion Locked

find a last record in access

0 helpful

1 reply

by addismul Jun 16, 2007 last reply Jun 16, 2007

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i want to find my last record enterd in the table

1 reply

If you have an identity column with integer as a key, it will be the biggest one.

If you have a date time created, and updates aren't too quick, it will be the most recent.

With neither you are going to have to add to the structure, or maybe use a trigger, to simply save the key of the last inserted record.

This discussion is closed to new replies.