number field

  • Thread starter Thread starter callie
  • Start date Start date
C

callie

Can I have a number field begin with, say, 5000, and then
go up from there? If so, how? Thanks!
 
Here is one way
1. Copy and paste the table design.
2. In the duplicate table, change the datatype from
AutoNumber to Number
3. Enter in one spurious row of data with 4999 in the
column that had the autonumber datatype.
4. Append this row to the original table.
5. Delete the appended row from the original table.
6. Delete the duplicate table.

Hope This Helps
Gerald Stanley MCSD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Beginning number of auto number field 5
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Combo look up, format from number to text field 8
Errors in Autonumber ID field 4
Trying to reduce number of fields 0
Number Field Question 3
Creating Lookup Field Between Two Tables 2
Transposing 0

Back
Top