I'm wondering if there is such a formula for this....?

Question

I'm working on a paper that I would like to automatically place a checkmark in certain cells if someone needs to attend a training.
I would like it to work like a mail merge, but with an "if" function. (I think)
For example, the form would read something like:
"Dear
Since you've been employed with us since
You are scheduled to attend the following training's"
Training 1
Training 2
Training 3
Not every person needs to attend every training. (we have roughly 1300 employees) So I would like to be able to simply have a check mark placed next to the training in a table.
I know that Access would be the way to do this,, but Im less competent with access then excel.
Seems like an "If" function would work, but I don't know how to write the formula.
Thanks to anyone who could understand this and help me!! :)

Answer 1

Whooo, that is a good one
I will be glad to make this file, based on user input and data, once you send me e-mail here in Y! Answers.

I love projects like these, and trust me I can do it.

Enjoy my profile, I am the VBAXLMan


PS: I can't send you e-mail, you will need to verify your e-mail address to Y! Answers

Send me the file here

[e-mail]

Answer 2

Several points here: You don't say why someone is required to attend one of the training sessions. For example, after being there 3 months they have to take Training 1. Your database has to track that requirement (whatever it is) and it is part of your "IF" statement.

Also you need to track if they have already taken Training 1 and that too is part of your "IF" statement.

Next I wonder if you are going to send out letters to all 1300 employees at once or one at a time or by groups.

Assuming you want to do them all at once, I'd use a loop.

The code would go something like this:

DO UNTIL = EOF ~(EOF is end of file)

If EmployedMonths (or whatever your requirement is) = 3 Then
If TrainingOneCompleted = False Then
chkBoxTrainingOne.value = checked
End If
End If

LOOP

The loop will go through your database and check each employee to see if they need to take training One. You'd set up 2 more IF statement blocks inside the loop to check if they need Training 2 or 3.

Hope that helps

Answer 3

maybe like
if check= true then
*checksign*training 1
else
*no check*training one
end if

and just loop that for all ur employees