I had a form that requiring a Job Order Code, "the Job Order Code is just like number of transaction". We had 12 months in 1 year. I need to reset the starting Job Order Code in every month. For Example:
January: In month of January I had 10 transaction, I started to number 1 up to the last transaction which is number 10. Notice the following month.
February: In month of February I had 8 transaction, I started to number 1 up to the last transaction which is number 8.
I had to reset the Job Order Code or number of transaction per month.
Every month must start to number 1 transaction, how can I do that? I know that you're knowledgeable and I know that you can help me. I am trying to solve this problem because on Monday will be the evaluation for the SYSTEM.
Thank you very much and more power!