Real Stumper!

  • Thread starter Thread starter Guest
  • Start date Start date
<nothing at all>


Yep. That's totally baffling - I couldn't see any way to solve it at all!


John W. Vinson [MVP]
 
John,
Please view post below the original. Thanks
Click to expand...

GMac, there are thousands of posts on this newsgroup. "Below" is meaningless
in this context; different newsreaders and web servers will display the posts
in different orders. I could do a Google Groups search for other posts with
you as the author but it would be a lot more efficient if you would either
post a reply to your own message (keeping the subject line unchanged) or copy
the message for a repost.

You may be making the reasonable assumption that your posts are stored only on
Microsoft's webpage. They're not; they're stored on every computer worldwide
which gets the NNTP feed from Microsoft. Not everyone (and very few of the
volunteers who answer questions) use the webpage interface.

John W. Vinson [MVP]
 
John,

Sorry for that, I assumed your view of the posts was the same as mine(which
were back to back). If you can help me with this, it would be great. Let me
know if I need to explain in greater detail, it get's confusing!

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
 
Back
Top