Problems using MAX(Column)+1 in INSERT INTO Statement

  • Thread starter Thread starter Martin Schmeller
  • Start date Start date
M

Martin Schmeller

Hi @all,

I need an example how to use MAX(Column)+1 in an INSERT INTO Statement to
insert unique increment numbers in a column while I insert records from a
second table.
I need INSERT INTO ... SELECT FROM ... with MAX(Column)+1 in it!!!

Greez

Martin
 
Hi,



Rank (1, 2, 3, 4, 5, ... ) the records to be inserted, then:


INSERT INTO table1 (f1, f2) SELECT Rank + (SELECT MAX(f1) FROM table1) ,
f2 FROM ...



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top