Select Last Number In Access

Sat, 07 Mar 2009 12:00:00 +0100

I have recently been working on a ticketing system and i needed to know how to find they next number for the primary key. Took me a while to find out how to do it in access so i thought i would share it.

Here is this SQL that i used.


SELECT LAST([Tickets.TicketID])+1 AS TicketID FROM Tickets

I know that with many of the better DBMS they can return the generated keys, But from what i found you can not do this with access.

If you have found any easier methods then please feel free to share them.

CFProject - SQL

Select Last Number In Access