number sequence

[lynn atkinson]

I have a table which holds employee id and candidate numbers. However, some
of the candidate numbers are blank and I would like to fill these in with
sequential numbers. I have 459 blanks and I dont want to input 1 to 459
manually. Is there a way of doing this with a formula or a query? It doesnt
really matter what order they go in as they are temporary numbers till the
real candidate numbers come through. I dont want a permanent autonumber here
either as the numbers will be entered manually when we get them.
Any ideas

 

[Lynn Trapp]

Can you post a sample of your data?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[mnature]

A somewhat quick and dirty way to do it, is to output all the information
from that table to excel, put the numbers in there, and the import the excel
file back into a table. Rename your first table (as a backup in case
something goes wrong), and then name the excel file table to the original
name. Excel is great for putting in a series of numbers. Not an elegant
solution, but workable.