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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…