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?

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