Originally Posted by
JoeM
What are you using for your determination of what is the "last" record?
Note that in Access, the relative position of a record in comparison to other records really has very little meaning (it is much different than Excel this way).
In Access, when you refer to the last record, it usually means in reference to some other field (i.e. "latest date", "highest id number", etc.).
If you want "last" mean the "latest entry added", you can add an AutoNumber field to your table, which begins at 1 and keeps incrementing every time a new record is added. Then this would give you a field which you could use to determine what the "last" record is (by taking the record with the Max Autonumber ID value).