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

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?