Page 1 of 1

List of those that are part of two skills, but not just one.

Posted: Thu Sep 23, 2010 4:24 pm
by BobWhite
I'm trying to get a list of people that are part listed as part of two activities/skills; not a list of people that are part of one or the other, but both. I thought I could do this through custom reports by using the "and" statement and giving two skill numbers like "skill number=100" "and" "Skill number=900." It works in the "or" statement, but doesn't work for the "and" statement. I have looked at a personal profile and at least one person has these two skill numbers listed as part of their profile, but the query brings back that there are "no records" that fit this filter. Any database should do this ... HELP ... what am I doing incorrectly?

Thanks, Bob. :D

Re: List of those that are part of two skills, but not just one.

Posted: Thu Sep 23, 2010 4:33 pm
by Zorak
Replied in your duplicate post over in Membership thread.