Help With Incrementing field number

[Neil2p]

I have a table that was imported from an existing Excel file, It has a field called ORDER No, this has been populated with consecutive numbers brought in from the original Excel file, I need to have this number incremented by 1 each time a new purchase order is raised, with this new number being displayed. Any ideas

[orange]

When you create a new Order you find the current max(OrderNo) and add 1. But there must be more to your database. Until readers know more about you and your set up, they can not offer focused assistance.

Is Order the same thing as Purchase Order?
Did you Normalize your tables? This is important (critical) in Access and other database systems.