How do I preset a number field from 000-999

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Small db to record school calendar sales. I need to preset/preload the
calendar number field with the values from 000 - 999 inclusive. Buyers data
will be assigned to a calendar number as it is sold. A combo box will use
these numbers to retrieve buyers data - name, address, etc. Is there a way
to do this with out using the autonumber feature?
 
This sounds like a one-time task. I would open Excel and create the numbers
there. Then copy and paste or import them into an Access table.
 
Willie@PHS said:
Small db to record school calendar sales. I need to preset/preload the
calendar number field with the values from 000 - 999 inclusive.
Buyers data will be assigned to a calendar number as it is sold. A
combo box will use these numbers to retrieve buyers data - name,
address, etc. Is there a way to do this with out using the
autonumber feature?
Click to expand...

If this is a one-time deal to get your table set up then I would create the list
in Excel and then paste it into your table.
 
Back
Top