Autonumber?? Is there a better way??

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

I'm sure this issue has been addressed over and over in
past posts, so I apologize......but any advice would be
greatly appreciated.
I'm creating a database for our dept construction
drawings. We would like to start fresh with a new method
of assigning drawing numbers to new records. We would
like to include the year along with an automatically
assigned sequential number (ex 2003-001). The intent is
to have this number automatically be created in
the "Drawing No." field when new records are entered. Any
ideas??
Thank you in advance.
 
Mac said:
Works great with one exception.
In the table, the CreationDate field displays "2003" and
the ID field displays "000". In the form, it
displays "1905-000". I can't figure out why the date is
showing up as 1905. Suggestions???
Thanks again.... newbie here.
Click to expand...

Creation date should be an actual Date, not the number 2003. If you are going to
just store the number of the year, then you don't need the Format([CreationDate],
"yyyy") part of the expression.
 
Back
Top