Record of members with different Status Codes

Moderators: Moderators, Tech Support

Post Reply
carpy01
Posts: 25
Joined: Tue Sep 15, 2020 7:33 pm

Record of members with different Status Codes

Post by carpy01 »

I need to create both a mail and email list for all the female / adult church members.
The list will be made up of church people who have different "Status Codes"
There will be eight status codes used for all the women.
I need to create an "and" list; active members and ass. members, and friends of the church and so on for eight codes.
I found something about "Grouping" but I don't know what this is. Or if I'm suppose to contain all the status codes into one group.
In Microsoft Access I would create a query with a string of code and code and code until I had selected all I needed.
Any help you can give would be greatly appreciated.
Thanks
Dave Carpenter

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

Re: Record of members with different Status Codes

Post by Zorak »

It sounds like you need "OR" connectors rather than "AND".

No single person can have all of those Personal Status Codes assigned, which is what is implied with the AND.

OR would be to include everyone that has active member OR associate member OR friends of the church, OR any of the other values.

carpy01
Posts: 25
Joined: Tue Sep 15, 2020 7:33 pm

Re: Record of members with different Status Codes

Post by carpy01 »

Yes you're correct I should have said "or" not "and". I caught my error after I sent. I sent another message right after to correct.
You must not have got it!
But my problem is the same I don't understand how to create an "OR" string in PowerChurch.
I can create the lists one status code at a time, but I don't see how to create an "OR" string.
Exp. "Active Member" OR "Ass Member" OR "Friends of Church" OR ---. For eight status codes.
Thanks for your help.
Dave Carpenter

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Record of members with different Status Codes

Post by NeilZ »

carpy01 wrote:
Wed Jun 09, 2021 4:11 pm
Yes you're correct I should have said "or" not "and". I caught my error after I sent. I sent another message right after to correct.
You must not have got it!
You started a new topic thus the reply to that question got lost.

Here's that topic: viewtopic.php?f=2&t=15726
Neil Zampella

Using PC+ since 1999.

Post Reply