Finding Blank Records

[wraith]

records

I have been asked to build a database with blank records already in the database, and number of records starting at L3000.
The user would find the blank number and fill in details. The idea is so I would produce a report that would show which numbers have been used.
Any ideas how I could get the database to automatically produce new blank records starting at L3000

 

[Tay]

This post should help you out with starting the autonumber at a number other than 0.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=56575&highlight=autonumber

However, will the figure always be prefixed with L? If so, there is no need to store the L. It's not a good idea to have a field with more than one piece of data in it.

 

[wraith]

If I don't put the letter with the record how would it save the record, L is not the only preffix.

 

[wraith]

Is there a way to generated records automatically, as each branch has a book of order numbers that they assign, the main offices wants to ba able to lookup the number and fill in the details. then produce a report to see if any order have been missed. The database would need to generate 100 records each month.