Correction to Women's email list.

Family Mailing List, Personal Profiles, Activities and Skills, Attendance, Visitations

Moderators: Moderators, Tech Support

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

Correction to Women's email list.

Post by carpy01 »

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

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

Re: Correction to Women's email list.

Post by Zorak »

The easiest thing would be to run one of the built-in reports in Personal Profiles, like Selected Names Addresses & Phones or Selected Profiles Full Details. The Selection Criteria screen that opens when you run a report in Personal Profiles has a Personal Status selection at the top right. It defaults to ALL. Click the All button, uncheck the ones you don't want to be included in the report. You can also make the selection in the Gender field to exclude men.

If you are wanting to export data to a file, rather than a formatted report, you can do that from under Personal Profiles > Other Output > Export Data. That process starts with the same Selection Criteria screen, so you can make the selections detailed above to get selected women in the file output.

Post Reply