troubleshooting Question

Previous record

Avatar of Derek Brown
Derek BrownFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
15 Comments2 Solutions224 ViewsLast Modified:
Hi all

I am entering data into a field on a continuos form.
I am trying to create a reference number in a field that is basically the two digits from the current month and an incrementing number starting at 1.  The increment must start at 1 for each new month and year.

This is to automate a File reference number so that when a customer is entering supplier purchase invoices they like to file the purchase invoice in monthly order. this reference number is then phisically hand written on each purchase invoice and is a number that allows users to find purchase invoices quickly in the filing cabinet. So all purchase invoices will have a ref for example a June invoice might be   06 12. That will be placed as the 12th invoice in the file for June. But I also need to make sure that when incrementing that the increment does not pick up last years June and increment from that largest number.

Whats the simplest way to do this?
Gerry Bartley
Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros