Autonumbers in Access

  interzone55 22:35 20 Feb 05
Locked

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.

TIA

Alan

  harps1h 22:56 20 Feb 05

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 05

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 05

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.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

Best Mac antivirus 2017