How can I generate customised Auto Number
Example: 001/02/11 Where 001 is auto serial , 02 is Month (February) and 11 is year.
or
Example: 001/Feb/11
Thx
Aamer
Competent Performer
Windows 7 
Access 2007
How can I generate customised Auto Number
Example: 001/02/11 Where 001 is auto serial , 02 is Month (February) and 11 is year.
or
Example: 001/Feb/11
Thx
Aamer
Master of Nothing
Windows 2K Access 2000
Check out "AutonumberProblem.mdb" at Roger Carlson's site:
http://www.rogersaccesslibrary.com/forum/topic395.html
Competent Performer
Windows 7 Access 2007
This did not help
Administrator
Windows 7 64bit Access 2010 32bit
Alright then, how about this link: http://www.baldyweb.com/CustomAutonumber.htm
Access Auto Number Help
Auto Number in Query
Posting Permissions
Reply With Quote