Search found 19 matches

by carpy01
Wed Jun 09, 2021 3:11 pm
Forum: Custom Reports
Topic: Record of members with different Status Codes
Replies: 3
Views: 243

Re: Record of members with different Status Codes

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, ...
by carpy01
Mon Jun 07, 2021 3:14 pm
Forum: Membership
Topic: Correction to Women's email list.
Replies: 1
Views: 29

Correction to Women's email list.

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
by carpy01
Mon Jun 07, 2021 10:58 am
Forum: Custom Reports
Topic: Record of members with different Status Codes
Replies: 3
Views: 243

Record of members with different Status Codes

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 ...
by carpy01
Mon May 17, 2021 12:36 pm
Forum: General Questions and Discussion
Topic: Queries list of veterans
Replies: 1
Views: 128

Queries list of veterans

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...
by carpy01
Wed Feb 03, 2021 2:21 pm
Forum: Custom Reports
Topic: Building a query!
Replies: 1
Views: 404

Building a query!

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...
by carpy01
Fri Nov 13, 2020 9:05 am
Forum: Membership
Topic: Adding fields named veteran and branch to person profile?
Replies: 3
Views: 157

Re: Adding fields named veteran and branch to person profile?

Thank you for your response.
Is there a way to change field "user1" to veteran?
Thank you for their help.
by carpy01
Wed Nov 11, 2020 1:48 pm
Forum: Membership
Topic: Adding fields named veteran and branch to person profile?
Replies: 3
Views: 157

Adding fields named veteran and branch to person profile?

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
by carpy01
Mon Oct 19, 2020 9:26 am
Forum: Membership
Topic: Still having problems with email lists.
Replies: 1
Views: 156

Still having problems with email lists.

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'...
by carpy01
Wed Oct 14, 2020 8:05 am
Forum: Membership
Topic: Making mass changes to ma and me tables.
Replies: 3
Views: 277

Re: Making mass changes to ma and me tables.

We may have to change the "Status Codes" of members.
Dave Carpenter
by carpy01
Tue Oct 13, 2020 9:32 am
Forum: Membership
Topic: Making mass changes to ma and me tables.
Replies: 3
Views: 277

Making mass changes to ma and me tables.

Do to aligning PCP with our church constitution, I need to make some mass changed.
Would it be possible to export PCP MA and ME tables to ACCESS, make all the changes
and someway import the updated tables back into our PCP software?
We have version 11.5.
Thank you for all your help.
Dave Carpenter
by carpy01
Mon Oct 12, 2020 3:30 pm
Forum: Membership
Topic: Changing the Person Profile status code name.
Replies: 1
Views: 224

Changing the Person Profile status code name.

Thanks you for all your past help.
Dave Carpenter
by carpy01
Sat Oct 10, 2020 12:27 pm
Forum: Membership
Topic: Creating Email Directory
Replies: 1
Views: 177

Creating Email Directory

Thank you for all your help in the past. I have two new questions: I'm confused about the use of having the email address on the Integrated Form. I don't understand the need for it? When I ran an Email Directory for our church all I got were email in the Person Profile Form. None of the Integrated R...
by carpy01
Mon Sep 21, 2020 3:47 pm
Forum: General Questions and Discussion
Topic: Registered and Update date fields.
Replies: 1
Views: 378

Registered and Update date fields.

In powerchurch 11.1 on integrated form, other information tab, what are the registered and update dates? The fields have dates in them however I don't know what they dates of?
Thank you for your response.
by carpy01
Mon Sep 21, 2020 8:00 am
Forum: Membership
Topic: Member count in a church directory
Replies: 2
Views: 197

Re: Member count in a church directory

Thanks again for your quick response.
Dave Carpenter
by carpy01
Sun Sep 20, 2020 6:44 am
Forum: Membership
Topic: Member count in a church directory
Replies: 2
Views: 197

Member count in a church directory

I created church directory using Family Mail List / Church Directory. How can I get a count of families without physically counting them? And I assume the church directory is being generated from the MA table- correct? I tried classic, detailed and column views however none show a total count. Thank...