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?
2 posts • Page 1 of 1
- Tech Support
- Posts: 2730
- Joined: Thu May 13, 2004 8:59 am
- Location: PowerChurch Software
Replied in your duplicate post over in Membership thread.