Newbies Friendship Printers Posted January 7, 2011 Newbies Share Posted January 7, 2011 my goal is to make script that creates a new job number(record) which is made up of the following information... month, year, then a rolling number starting at 001. I'd like the rolling number to begin 001 on the first of every month and reset back to 001 on the first day of the next month. so if it started today, my number would be 111001. If we did 200 jobs this month, then my job numbers for January would be 111001 - 111200. On the first day of February, the script would automatically change to 211001. Thank you in advance for any help in creating such a script. Rob Hunt Link to comment Share on other sites More sharing options...
dansmith65 Posted January 9, 2011 Share Posted January 9, 2011 I'm not quite sure how you'll do this, but if you ever figure it out I'd highly recommend changing the format to year, month, number like... YYMM### -or- YYYYMM### This will cause records to be displayed in chronological order when you sort by this field. You could try using a calculated field, or the Set Next Serial Value script. although, instead of this format, I would suggest a standard auto-increment primary key field and an order/entry date field (could also be auto entry). This should allow you to run a report that shows you how many jobs you've entered per month. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4856 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now