Displaying Data

D

DayWalker

Well-known member
Joined
Jul 9, 2003
Messages
51
How would i go about displaying a number to the user from a field that is incremented (AutoGenerated) by 1 each time a row is added. I need to display the number via a msgbox to the user the minute a row is added. Is there a way to get the last possible record in the table and +1 to the number.
 
you can write a sql statement that will retrieve the maximum number, which would be the last possible record
 
Back
Top