show only LAST entry made

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

Guest

What query statement would allow me to out put only the last entry made into
the DB.
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter queries that allow users to choose items from a list 3
View Last Report Only. 3
Notepad status bar missing even after Registry entry 1
Want last record only from a 1 to many linked table. 3
Running a query that only shows the latest entry 2
Show last date only. 3
How do I find the last record ? 5
Run last 24 hours. 5

Back
Top