Increase last number used by 1

[tony curtis]

I have a list of order numbers and want to increase the last number used by 1 and store the latest number in a table.

Autonumber does not work for me as all the data is in a table already.

New to SQL so please help in non-technical (idiot way) explanation

thanks

[Twanne]

Bit more explanation would be handy.

But I think what you want is to select the last number in your table and than increase it with one and then just write it back to the (or another) table.

There are sql functions wich let you return the first (or last if you change order) record from a table.

Greetz

[tony curtis]

Bit more explanation would be handy.

But I think what you want is to select the last number in your table and than increase it with one and then just write it back to the (or another) table.

There are sql functions wich let you return the first (or last if you change order) record from a table.

Greetz

Sorry

im trying to create an order book that takes the last order number used and then creates a new order number ie. last order number plus 1 .

This saves the order with that order number in a table and on a new order gives the new order the next order number.

The order number up to now has been a manual system, look back to the last order and add 1.

However as the table is in use I cant put an auto number on it.

thanks for any help

Tony

[abolos]

I have a list of order numbers and want to increase the last number used by 1 and store the latest number in a table.

Autonumber does not work for me as all the data is in a table already.

New to SQL so please help in non-technical (idiot way) explanation

thanks

You may try this:

Select MAX(field that has the number).....

This MAX will bring the last number in the order and then you can use the INSERT SQL command in order to insert it in another table.

abolos

[missinglinq]

NewOrderNumber = DMax("[OrderNumberField]", "TableName") + 1

Welcome to TheScripts!

Linq ;0)>