SteveL13
asked on
How autopopulate number field with 2 different criteria
I have a form with a 5-digit number field that I want to auto-populate with data when a new record is entered. The first three digits are to be sequential starting with 300. The second 2 digits are to be filled with last 2 digits of the year. So if the new record was created today the auto-populated field would be 30016.
But here's the catch. The year is a fiscal year starting March 1 and ends the last day of February. So the year isn't just a calendar year, it is a fiscal year.
How can I do this?
But here's the catch. The year is a fiscal year starting March 1 and ends the last day of February. So the year isn't just a calendar year, it is a fiscal year.
How can I do this?
what would be the first value when the date is 3/1/2017?
is it gonna be 30017 or continue to accumulate the first three digits, i.e., 31217
is it gonna be 30017 or continue to accumulate the first three digits, i.e., 31217
ASKER
It would be the next sequential number from where we left off with the previous record. So for example, if on 2/28/2017 our last record was 37616, then the first new record on 3/1/2017 would be 37717.
I hope this makes sense.
I hope this makes sense.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All excellent solutions and recommendations/comments. Thank you to all.
Open in new window