Locating the last table entry

  • Thread starter Thread starter Paradigm
  • Start date Start date
P

Paradigm

I have an Access front end linked to sql tables. After a new record has been
added to a table I need to process some data. I was locating the last new
entry by running a query to find the max ID which should be the latest entry
since th id was an autonumber field. I have now modified the system to
synchronise tables and the id is now a GUIID. The query no longer returns
the last entered record.
How can I determine the last entry in an sql table.
Thanks.
Alex
 
I have an Access front end linked to sql tables. After a new record has been
added to a table I need to process some data. I was locating the last new
entry by running a query to find the max ID which should be the latest entry
since th id was an autonumber field. I have now modified the system to
synchronise tables and the id is now a GUIID. The query no longer returns
the last entered record.
How can I determine the last entry in an sql table.
Thanks.
Alex
Click to expand...

if you include a timestamp in the record, you can get the top 1 value
from the table and return the last record.
 

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

Pulling data from a linked SQL table 2
Data Entry Form and Auto Number ID 2
Subquery Correllated In Select Clause - Is this possible? 3
How can I get the last row that was inserted in a table 4
How do I get rid of "Auto Number" in forms ? 7
SQL Upsizing Problem with Left Join Queries 19
Autonumber issue 2
Query to Pull Most Recent Call with a Callback Date Scheduled 10

Back
Top