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!

do not post same thread more than once
check your previous post for an answer.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.