Simple Append Query Help

[RRMESLTD]

Can anyone help please, I am really stuck on this & am not sure where I’m going wrong.


I have to create an Access database that auto generates an order number, which is straight forward enough using autonumber etc. The problem I have is I need to start of at a certain order number ie: 101151. Can anyone help with the append query, I cannot get it to copy over the prior order number 101150, for which the autonumber will continue from.


Any suggestion of where I’m going wrong.
I have 2 tables , Orders & Orderstemp (contains only the ordernumber 1011500)


Orders Table Orders Temp
* *
OrderID OrderID
CustomerID
OrderDate


What do I do next ?



Any help would be greatly appreciated!

 

[buckeye_td]

Create a query in design view and add the Orders Temp table. Place the field OrderID in your first column. Change the query type to Append (from the Menu under Query or from the drop down 'Query Type' button on the toolbar) and in the Append To Table Name field, enter Orders Table. Then run the query and it should append 1 record.

TD