filtering by Skill Number
Posted: Wed Nov 10, 2004 12:30 pm
Hi there,
I'm trying to create a custom report based on Skill Numbers that people may or may not have, and need your help/advice.
In our database, we assigned Skill Number 1 as Plan to Protect, a training for those dealing with minors. Skill Number 1100 is for those involved in Youth Ministry.
What I want to do is create a report where I list all members currently involved in Youth Ministry, but who have NOT yet finished the Plan to Protect training.
i.e. Skill Number equal to 1100 and Skill Number not equal to 1
However, I cannot get the Custom Report to correctly select these people. Any thoughts?
Blessings,
Graham Faulkner
gfaulkner@watpen.org
I'm trying to create a custom report based on Skill Numbers that people may or may not have, and need your help/advice.
In our database, we assigned Skill Number 1 as Plan to Protect, a training for those dealing with minors. Skill Number 1100 is for those involved in Youth Ministry.
What I want to do is create a report where I list all members currently involved in Youth Ministry, but who have NOT yet finished the Plan to Protect training.
i.e. Skill Number equal to 1100 and Skill Number not equal to 1
However, I cannot get the Custom Report to correctly select these people. Any thoughts?
Blessings,
Graham Faulkner
gfaulkner@watpen.org