G
GMac
I am seriously lost at this point! Please Help!
I have a table with associate ID, FirstName, LastName, StartStep, Program
Start date.
I also have a query that takes all training courses completed by the
associates and groups them into required training steps.
Associates take a placement step before they start the program, which they
can test out of steps. This is entered into the database as "StartStep".
Each step is required to have 6 months of job work along with the training
module for that step.
I would like the report to start the associates step date at the step
following the test out steps. (associate steps of of 1 & 2) program start
date begins at step 3.
After a start date is entered in the correct (1-5) it needs to be every six
months after. There are 8 total steps.
For each step, if the training is complete when the step date hits, then the
associate is advanced.
How can I start the date at a given step depending on the start step.
start step = startstep else "Test Out" something along those lines?
What would I do to replicate the date by 6months for the following steps.
Is there a way to make the fields highlighted to show if the training for
that step is complete? Or maybe checkboxes?
I can better explain this whole thing if you need more answers.
THANKS
I have a table with associate ID, FirstName, LastName, StartStep, Program
Start date.
I also have a query that takes all training courses completed by the
associates and groups them into required training steps.
Associates take a placement step before they start the program, which they
can test out of steps. This is entered into the database as "StartStep".
Each step is required to have 6 months of job work along with the training
module for that step.
I would like the report to start the associates step date at the step
following the test out steps. (associate steps of of 1 & 2) program start
date begins at step 3.
After a start date is entered in the correct (1-5) it needs to be every six
months after. There are 8 total steps.
For each step, if the training is complete when the step date hits, then the
associate is advanced.
How can I start the date at a given step depending on the start step.
start step = startstep else "Test Out" something along those lines?
What would I do to replicate the date by 6months for the following steps.
Is there a way to make the fields highlighted to show if the training for
that step is complete? Or maybe checkboxes?
I can better explain this whole thing if you need more answers.
THANKS