Custom Sequential autonumber of different series

[binitbegwani]

Dear Sir/Madam,


I am using Ms Access 2007 and I am new to it


I have table of following fileds


ID (as a primary key)


AccountingYear (Filed for current accounting Year e.g., 14-15; 15-16)




Series (text- as R, Y, B etc to denote series code)


OrderNo (field to store custom autonumber Order No e.g., for Series R-1, R-2, for series Y Y-1, Y-2, etc)


I have created a form using all these fields


Now what i want to do is I want to create custom order no as


first 2 digit of accounting year+Series+Autonumber of respective series as


14R-1
14R-2
14Y-1
14Y-2
14Y-3
14B-1


15R-1
15R-2
15Y-1
15Y-2


Means autonumber starts with 1 for every accounting year of respective Series


Please guide me as how to do this and what code or formula should be applied and where the code should be inserted as I am new to Ms access

[June7]

Generating custom unique identifier is a very common topic. Search forum. Here's one https://www.accessforums.net/access/...ers-21361.html

[CJ_London]

this is a common requirement which has been answered many times. If you look at the bottom of this thread you will see links to a number of threads on the same subject. Take a look through those and come back if you get stuck

[CJ_London]

just seen you have an identical post on another forum - please have a look at this link

http://www.excelguru.ca/content.php?184