autonumber

A

andym

I have a prime number (autonum)
in table format "IF-04-"000 so it reads as IF-04-001 next
record IF-04-002 and so on. Once it becomes 2005 I need
to change to IF-05-001 and continue like i did from the
beginning. So 05 will change and 001 will start again.
 
N

Nikos Yannacopoulos

Andy,

I'm afraid you acnnot do that with an autonumber... Your
format only affects the way you see the number, to Access
the number is actually 1,2,3... so IF-04-001 and IF-05-001
are both plain 1, which there's no way you can make Access
accept in an autonumber field, or any other PK field for
that matter. To do what you want you need to change your
PK to a text field and assign values some other way (e.g.
use default value or a macro or code to assign new PK
value in a record enrty form).

HTH,
Nikos
 

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

Top