create next highest number

B

Burt O

Could someone give me an examble of how to use a VBF to create the next
highest number in the database. I can not use Auto Number as the table
sometimes needs to exported and then imported back in
 
S

Stefan Hoffmann

hi Burt,

Burt said:
Could someone give me an examble of how to use a VBF to create the next
highest number in the database. I can not use Auto Number as the table
sometimes needs to exported and then imported back in
Click to expand...
As query:

INSERT INTO Table (ID, Field1, Field2)
SELECT Nz(Max(ID), 0) + 1, Value1, Value2 FROM Table


mfG
--> stefan <--
 
Top