Autonumbers in Access

  interzone55 22:35 20 Feb 2005

Here's am extension of a question I asked last week

I need to add a serial number to records in a table.
The serial number needs to ne in the format of - Short form of current month, plus a 3 digit number, eg FEB555.
This has really got me stumped, I've tried several suggestions like [mmm]000, this gives DEC000, JAN000, FEB000 etc.



  harps1h 22:56 20 Feb 2005

try using the input mask as you have been doing. then alter the text on your general table when in design view.

  WaTcHiNg 00:31 21 Feb 2005

I'm toying with the same problem but since I'm using it for a sales database Im gonna go with a number field and add the correct number via the web sales system.

I think the following gives you what you want but heed the warnings:

click here

  AccessMoron 11:40 23 Feb 2005

ITs not that easy to explain it, but if you want email me and i will send you a simple database that will do what you want

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)