Page tree

When you use the Advanced Search feature, Access ACS uses two types of searches OR searches and AND searches. The search criteria you select determines the type of search Access ACS uses.

 When To Use Searches

The following table provides information about when each type is used:

Section Name

Search Type Between Sections

Search Type Within Section

Activities

  • OR with classes and small groups
  • AND with other sections

OR

Classes

  • OR with activities and small groups
  • AND with other sections

OR

Small Groups

  • OR with activities and classes
  • AND with other sections

OR

Birthday

AND

AND

Address Fields

AND

AND

Individual Fields

AND

OR

User-Defined Fields

AND

OR

Comments

AND

AND

 OR Searches

When Access ACS uses the OR search type, the search results display individuals who meet at least one of your search criteria.

With Multiple Sections - When you select multiple search criteria from the activities, classes, and small groups sections, Access ACS uses the OR search type. The search results include individuals who belong to at least one of the groups you select.

For example, you want to find all individuals who belong to the Music Program activity or the Women's Sunday School class. You select the activity and the class and run the search. Your search results display members who belong to either the Music Program activity or the Women's Sunday School class.

In the Same Section - When you select multiple search criteria from the same section, Access ACS uses the OR search type. The search results include individuals who match at least one of the search criteria that you select.

For example, you want to find individuals who either attend Sunday school only or attend bible study only. You can select the member status options and run the search. Your search results display members who either attend Sunday school only or attend bible study only.

 AND Searches

When Access ACS uses the AND search type, the search results display individuals who meet all of your search criteria.

With Multiple Sections - When you select multiple search criteria from some sections, Access ACS can use the AND search type. The search results include individuals who meet all of your search criteria.

For example, you want to find individuals who belong to the 40 Days of Purpose small group and who have birthdays in July. When you run the search, individuals who belong to the group and have birthdays during July display.

In the Same Section -When you select multiple search criteria from a single section, Access ACS can use the AND search type. The search results include individuals who meet all of your search criteria.

For example, you want a list of individuals who live in Florence, South Carolina, on Palmetto Street. In the Address section, you enter the search criteria and run the search. The search results display individuals who live in Florence, South Carolina, and on Palmetto Street.

 

 



Related Topics