How do I preset a number field from 000-999

W

Willie@PHS

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?
 
D

Duane Hookom

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.
 

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

Check for existing date in record and duplicate record if date fou 0
How do I clear a form? 0
How do I ..... 8
Need advice - will a form do this? 6
Input Mask into Text Box - Phone Number - Help! 12
One-to-one relationship 2
AutoNumber -- block of numbers for ea user -- maxumum auto number 4
Inserting a concatenated string into a text field 2

Top