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
 
Back
Top