Sequential Numbering with a difference!

[RHouse]

I have an existing table with a field labelled Job Number (17 Job Numbers). Each month I import a new table and match each record via another field (serial number). For each new record, one or many, I want to attach a sequential Job Number. In this example the new job numbers need to start at 18 then 19 etc. How is this possible? I am fairly new to Access so please be gentle!. Cheers

 

[Birdy]

In the format field of the Autonumber properties. Set this format to the number you want to start at. i.e. \10 or \20 or \1000

 

[RHouse]

Thank you for your help but I believe I am no way forward...

I introduced a new field (Job Number) into my import query and formatted \18. All this achieved was all records were labelled as Job 18. This dataset could be both existing data or new data. Carrying out this process would overwrite all previous jobs...This is not I want to achieve unless I have missinterpreted your instruction. Below is a bit more detail to my problem.

The new table does not have the job number field upon import. A make table query introducing a new field (Job Number), where I cannot set the data type to Autonumber, is run to establish which serial numbers are new. I would like to attach a sequential Job Number starting at the next record from the existing data set i.e. Job 18 then Job 19 etc. How is this possible?Cheers