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

 

[CJ_London]

duplicate post here

http://www.accessforums.net/forms/custom-sequential-autonumber-different-series-54514.html