Increment number

[NightFeeder]

Hi,

I have a table with a date and number fields.
The number field must start at 1 (default) and increment with each job-card created on that date.
For instance: Jan 1,2002 Job:1
Jan 1,2002 Job:2
.
.
.
Jan 1, 2002 Job:30
Jan 2, 2002 Job:1

One additional requirement is that more than one user can log jobs and that the job number for each must be unique, thus the column must be locked until a number is created.

Thank you for your time and effort.

 

[gol4]

See the FAQ posted by Michael Red in Access other topics

can do another method using dmax() function but not as dependabale in a mulituser environment.