User Support Forum

11/29/23. Thanks for your response. We're using version 14.4. And yes I agree not including address infornation was foolish. However like I said I inherited this program. We had three data entry people before me. Right now the only way I can see is to delete the recods one at a time = will get MA an...

11/28/23. I inherited a PCP program at our church. In the MA table I have 320 records with no addresses. Many are "active Members". When I try to create a list from Intergated Table, I get all of these with no addresses. So list of lebels wastes a bunch of labels. I tried creating a query in PCP, bu...

08/24/23. Neil thanks for responding. There are only 5 notes fields in Person. Profile. I have already used all of them. The member who asked for this addition, needs 4 fields = card number, card code, date issued and date replaced. He also needs names, addresses, phone and email which I can get fro...

08/23/23 The church installed card readers on the doors. Member need a code card to come in certain doors I have been asked the enter all these cards information into Power Church by member's name. I think the only way to do this in PCP 14 is to use the Maintain Equipment Inventory Form. However I n...

03/04/23 Need emails per person from ME table based on 9 status codes I can use the "Email Directory" to create a report. However the report shows records where the email field is null, blank or empty (I don't how that field was formated). When I set it up in ACCESS, query email criteria = Is not nu...

03/23/23 I create the members email list for our church. My problem I want to include emails from 9 status codes, without fields with no email. PowerChurch will not do, except for one status code at a time,. So I built a query in ACCESS to create the list. Copied the MA and ME tables to ACCESS. Run ...

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, ...

I just asked for help with query to list all women of church.
Said I need help with "and" statement.
I made mistake I need to use an "OR" statement.
Women have different status code and I need "code" OR "code" OR "code".
Best example I need to removed Deceased from list!
Thanks
Dave Carpenter

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 ...

I assigned code 5 as veteran and created a pull down to select branch of service. Now I want to create a email list of all the veterans in our church. In trying to create a custom report. I can't find the field called "code 5", all I see is codes 1,2,3. I was going to query code 5 field as "not null...

I've been asked to generate a report of all the female members of the church and their email addresses. I can't figure out how to get, what I get is a list of names from the Integrated Form "Household Key". Carpenter, Dave and Judi and the email on the Integrated Form (Dave's email). Many of our fem...

Thank you for your response.
Is there a way to change field "user1" to veteran?
Thank you for their help.

I would like to keep track of all members who served in the military.
I note there are five user fields, would these fields be the best to assign to "Veteran" (yes or no) and "Branch" with pull down with branch name?
Thank you before hand for your help.
Dave Carpenter

Thanks you for all your help in the past. I have a new problem. I was asked to create three lists. The Church Directory. Can use the programs Church Directory. The Church Women's Email List . Can use the Email Directory w Gender = F and Adult = Y. Then an Email List for the monthly newsletter. Here'...

We may have to change the "Status Codes" of members.
Dave Carpenter