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...