how do i include the current year in an autonumber field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to include the year value as precedent to an autonumber in table design
Can anyone help?
 
I need to include the year value as precedent to an autonumber in table design
Can anyone help?
Click to expand...

You can't.
All you can do is concatenate the AutoNumber field (on a form or
report, or query, but not in the table) with the date year:
=Format(ADateField],"yyyy") & [YourAutoNumField]

If you need to have the value return to 1 for each new year, then you
can not use autonumber.... You'll need to create your own counter.
 
You must log in or register to reply here.

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

Similar Threads

Change the starting value of an AutoNumber field 3
Autonumber field changes to random from sequential 3
autonumber field type 2
Autonumber associated with date 0
Change primary key from autonumber to text field? 1
autonumber not working 0
Autonumber records inserted in gaps 1
What are AutoNumber Dangers 11

Back
Top