how do i include the current year in an autonumber field

J

jbl

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

fredg

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

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.
 

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