Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last inserted id

Status
Not open for further replies.
melaniecarr23

melaniecarr23

Programmer
May 2, 2005
79
US
Is there a way to use the last inserted id from a table in a query?

thanks,
Melanie Hayes
 
Sort by date Sort by votes
If the ID is an autonumber you may consider the DMax function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
as long as the db is STRICTLY single user. Otherwise, it is better to create your own and just save it for your immediate use. One way to do so is illustrated in faq700-184.





MichaelRed


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
754
renigar
renigar
TK-N
  • Locked
  • Question
MS Access Auto ID
Replies
1
Views
126
Darrylles
Darrylles
meagain
  • Locked
  • Question
Identifying Users in Access 2016
Replies
2
Views
181
strongm
strongm
tav1035
  • Locked
  • Question
access formula approach (RD workorders within 15 days of the closing of the last PM workorder)
Replies
1
Views
104
lameid
lameid
techjules
  • Locked
  • Question
Need query to only give last date of record
Replies
10
Views
149
techjules
techjules

Part and Inventory Search

Sponsor

Back
Top