Customizing AutoNumber Field

  • Thread starter Thread starter mario
  • Start date Start date
M

mario

How can we make an "AutoNumber" field generate auto-
numbers in a specified

format like for example:
sample-dt-000001
sample-dt-000002
sample-dt-000003
etc., instead of just 1,2,3

Pls help.
Thanks
Mario
 
Mario

Access Autonumber doesn't do that. And if you want not to have headaches
later, you won't do it either. What you described looks a lot like what
belongs in 2 or 3 separate fields. If you want to DISPLAY a collection of
fields as you outlined, you can use a query to do so for your forms ... you
ARE using forms, not entering directly in the tables, right?!
 

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

Need help with design pls 5
Creating Field With combo of autonumber and text 3
table recursion 5
Counting 1
auto number format 9
Query to separate a table containing many sub tables 1
create serial numbers 3
Autonumbering Old Records 2

Back
Top