reset counter depending on month

[garryhinch]

I would much appreciate help with the folowing problem.
Alongside a date field I need a job number using the following example:
Date Job No
Jan 1 05 Jan.1
Jan 2 05 Jan.2
Jan 2 05 Jan.3
Feb 1 05 Feb.1
Feb 5 05 Feb.2
The data in the Job No field is generated every time a new date is entered in the date field.The number in the job number field must reset to 1 each time the month changes.No problems using a report's grouping and running sum features but I need this in a form.
Have tried a number of different functions using loops but they all fall short of a complete solution.
Thanks in advance for assistance with this.

 

[PHV]

You may take a look here:

http://www.tek-tips.com/faqs.cfm?fid=184

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244