S
Swins
We are currently moving a paper based work system to access database, I
have created the tables and linked them to forms, but I am struggling
to make a field that will continue our numbering system automatically.
We currently use a system of month/year/unique number from 001
increasing by one for each job.
i.e. 08/06/123, the month and year are based on the time the record is
created.
I have tried several different ways, but not had complete success. I
can't change the numbering system so don't suggest this.
Any other ways of doing this?
Thanks.
have created the tables and linked them to forms, but I am struggling
to make a field that will continue our numbering system automatically.
We currently use a system of month/year/unique number from 001
increasing by one for each job.
i.e. 08/06/123, the month and year are based on the time the record is
created.
I have tried several different ways, but not had complete success. I
can't change the numbering system so don't suggest this.
Any other ways of doing this?
Thanks.