Creating custom auto numbers

  • Thread starter Thread starter Jaco Pretorius
  • Start date Start date
J

Jaco Pretorius

Can one create a numbering system in a table that will
generate customised numbers automatically?

When one uses the autonumber selection it only generates
a number. I want to add "W" before the number? Can this
be done?

Please assist.
 
Jaco Pretorius said:
Can one create a numbering system in a table that will
generate customised numbers automatically?

When one uses the autonumber selection it only generates
a number. I want to add "W" before the number? Can this
be done?
Click to expand...

If it will always be a "W" then you don't need to store it. Just append it for
display on forms and reports.

=Format([NumField],"\W0000")
 
Create two fields, one being the autonumber and the other with criteria:
'W' & tablename.fieldname (where tablename = the name of your table and
fieldname = the autonumber field)
 
Back
Top