Increment To Next Order Number Automatically

G

Gregg

I created an append query that pushed 100's of orders
form one table into another. I'd like to assign a new
order number to each order as I append them to the new
table based upon the maximum order number already found
in the "append to" table + 1.

Any help is appreciated.

Gregg Horwitz
 
Top