Using MS Access/Question Access 2010

Advertisement


Question
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

Answer
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

Volunteer


Scottgem

Expertise

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

Experience

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

Organizations
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

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.