Forums

This topic is locked

Formatting Access fields

Posted 23 years ago
1
has voted
23 years ago Bec C posted:
Off-topic I know!

Is there a way in Access to autonumber a field based on a unique format e.g.

rather than numbering records 1/2/3/4/5 and so on can I do this:

0001/0002/0003 ??

Can these then be manually edited if needs be?

Replies

Replied 23 years ago
23 years ago Joel Martinez replied:
nope, unfortunately not... The only options you have with an autonumber field in access is <b>Increment</b> and <b>random</b>

in SQL server, you can do that by using the "seed" (which is whatever number you want to start at) and you can also set how much to increment the number by...

Joel Martinez

----------
Is this thing on?....

Reply to this topic