G
Guest
I am currently building a database to manage the various projects that are
worked by field employees. I am wanting the project number to automatically
calculate based on the project type and the location that is working it. An
example of our project numbers is 16217-001 where 16 is the type of project
worked, 217 is the location number and 001 means this is the first project
for this location. As a result, I am wanting Access to generate the next
project number for this location of this type as 16217-002.
Any help is appreciated. Thank you.
worked by field employees. I am wanting the project number to automatically
calculate based on the project type and the location that is working it. An
example of our project numbers is 16217-001 where 16 is the type of project
worked, 217 is the location number and 001 means this is the first project
for this location. As a result, I am wanting Access to generate the next
project number for this location of this type as 16217-002.
Any help is appreciated. Thank you.