Creating an auto-incrementing serial number

[Keith Woollacott]

I am trying to create a database to record work carried out on our 43 sites.
Each record will have an autonumber ID, but it also needs an additional
reference number.

The number needs to be made up of 3 parts - the site reference number (7001,
7002 .... 7044), the last two digits of the year, and a number that is
incremented by 1 from the last used for that site. (e.g. "7003/07/001").

Any advice would be appreciated.

Keith W

 

[John Nurick]

Hi Keith,

Use three fields, one for each part. For the second part, set the
default value of the field to
Format(Date(), "yy")

For the third part, use one of the standard techniques for creating an
auto-incrementing number; searching these newsgroups (e.g. at
groups.google.com) will find them.

 

[Keith Woollacott]

John - I guess I was trying to be too cleaver for my own good!

Many thanks

Keith