Using MS Access/Question Access 2010


Hi - I am currently setting up a database for quality control inspections. On the main table there is the AutoNumber but I need to generate a unique Inspection Number for reports. They need to be according to Fiscal Year. (Oct1-Sep30)"FYXX-000"

So for 2015 the format I need it to auto generate is "FY15-"000. Any help would be greatly appreciated

Thank you

Please review my blog entry (see blog address in sig) on Sequential Numbering. it details techniques you can use to create a Sequential Number for each fiscal year.

You do need to determine what the Fiscal year will be fore any record.

If you have any questions after reviewing the blog, please feel free to ask.  

Using MS Access

All Answers

Answers by Expert:

Ask Experts




I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.


I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Brooklyn College BA

©2017 All rights reserved.

[an error occurred while processing this directive]