autoincrement field with added numbers

[j0se]

Hi peeps,

hoping somebody can help me with this one:

I have a PK field called ID. It's value is autonumber but I want to add to that the month and year

eg: 41.02.04
42.02.04
43.02.04

Does anybody know how to go about this?

 

[WayneRyan]

jose,

Autonumbers are just that - Numbers. They only hold numbers,
not xx.xx.xx.

Also, you can't assign values to them.

You'll have to use another field.

Wayne

 

[j0se]

ok

Got that

cheers

 

[a.sinatra]

But you could do this, leave the autp number alone, add a new field, and set the default to "=Date()" that what you could use that information how ever you like
________
SEX VIDEOS

 

[j0se]

sigh

OK - this is the way I'm going about this

I have an ID field, set to auto_increment and a JobID field, set as PK

In my form, I have some code behind the ID textbox control's AfterUpdate event:

' add this ID num to the JobID plue other bits...
JobID.text = ID.text & "test"


==
But it ain't working

Any more pointers please?

 

[j0se]

thanks

PS JobID is not numeric - it's text

I fixed it by creating and deleting a dummy entry "." in order to trigger the auto_increment field (ID). From thereon I can just get the value fo ID and append it to what I need

Cheers all