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

Moderators: Moderators, Tech Support

Locked
BobWhite
Posts: 4
Joined: Tue Sep 21, 2010 6:25 pm

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

Post 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

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

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

Post by Zorak »

Replied in your duplicate post over in Membership thread.

Locked