G
Guest
I have a database that uses a project number as a key in two tables. The
project number is similar to 16217-001 where 16 is the project code, 217 is
the location and 001 refers to this being the first project for the location.
I am trying to create a code or expression that will give me the DMax of the
last three digits for each project and location.
Basically, if I have a second project for location 217 for a 16 project, I
want access to generate this for me.
Any help will be appreciated.
project number is similar to 16217-001 where 16 is the project code, 217 is
the location and 001 refers to this being the first project for the location.
I am trying to create a code or expression that will give me the DMax of the
last three digits for each project and location.
Basically, if I have a second project for location 217 for a 16 project, I
want access to generate this for me.
Any help will be appreciated.