How to initiate record number on new year?

  • Thread starter Thread starter 23510VA
  • Start date Start date
2

23510VA

We have been using Access97 based database in a clinical laboratory for
last three years. I would like to start specimen number as 04-00001 for
the year 2004 in the existing specimen table, which as number
03-XXXXX.
Your help will be highly appreciated.
 
23510VA,

I guess the implication of your message is that the 03- at the
beginning of the specimen number is inserted automatically via some
process or another (e.g. Default Value setting, macro, VBA procedure,
or whatever). Do you know how this is done at present? It is
possible that the digits are automatically taken from the current
year, so as soon as you hit 2004 the specimen numbers will display as
04- without you having to do anything... wait another 18 days and
you'll know :-) And then there's the suffix part of the number. Once
again, it really depends on how these numbers are presently entered or
generated.

- Steve Schapel, Microsoft Access MVP
 
Back
Top