show only LAST entry made

  • Thread starter Thread starter Guest
  • Start date Start date
thrashcat said:
What query statement would allow me to out put only the last entry made into
the DB.
Click to expand...


Depends on how **your** data fields can be used to determine
whatever you defined as the "last" entry.

A table has no inherent attribute for the order of record
creation. You must provide one or more fields in each
record that you can use for this purpose. A field with a
default value of NOW() is a common approach. (Note: an
AutoNumber field is not a reliable indicator of the order
records were added.)
 
Back
Top