Search found 25 matches
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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, ...
- 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
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
- 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 ...
- 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...
- 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...
- 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.
Is there a way to change field "user1" to veteran?
Thank you for their help.
- 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
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
- 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'...
- 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
Dave Carpenter