Search found 25 matches

by carpy01
Wed Nov 29, 2023 1:14 pm
Forum: Membership
Topic: MA table, active members with no addresses.
Replies: 3
Views: 2805

Re: MA table, active members with no addresses.

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...
by carpy01
Tue Nov 28, 2023 10:20 am
Forum: Membership
Topic: MA table, active members with no addresses.
Replies: 3
Views: 2805

MA table, active members with no addresses.

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...
by carpy01
Thu Aug 24, 2023 2:37 pm
Forum: Other Modules
Topic: Maintain Equipment Inventory
Replies: 3
Views: 2571

Re: Maintain Equipment Inventory

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...
by carpy01
Wed Aug 23, 2023 1:50 pm
Forum: Other Modules
Topic: Maintain Equipment Inventory
Replies: 3
Views: 2571

Maintain Equipment Inventory

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...
by carpy01
Fri Mar 24, 2023 1:37 pm
Forum: Membership
Topic: Null fields in tables
Replies: 3
Views: 3343

Re: Null fields in tables

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...
by carpy01
Thu Mar 23, 2023 2:39 pm
Forum: Membership
Topic: Null fields in tables
Replies: 3
Views: 3343

Null fields in tables

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 ...
by carpy01
Wed Jun 09, 2021 4:11 pm
Forum: Custom Reports
Topic: Record of members with different Status Codes
Replies: 3
Views: 3430

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 4:14 pm
Forum: Membership
Topic: Correction to Women's email list.
Replies: 1
Views: 2738

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 11:58 am
Forum: Custom Reports
Topic: Record of members with different Status Codes
Replies: 3
Views: 3430

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 1:36 pm
Forum: General Questions and Discussion
Topic: Queries list of veterans
Replies: 1
Views: 1829

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: 3984

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: 3507

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: 3507

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 10:26 am
Forum: Membership
Topic: Still having problems with email lists.
Replies: 1
Views: 2918

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 9:05 am
Forum: Membership
Topic: Making mass changes to ma and me tables.
Replies: 3
Views: 3993

Re: Making mass changes to ma and me tables.

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