2,004
edits
Changes
no edit summary
If the criteria is for a different field, then you enter the criteria under that field. The system will imply an '''AND''' between the columns. For example:
{| borderclass="1" cellpadding="5wikitable"
|+
!Field!!Title!!Last Name
* Select the records where the title is equal to President '''AND''' the Last Name begins with '''A'''.
{| borderclass="1" cellpadding="5wikitable"
|+
!Field!!Title!!Last Name!!First Name
If you enter a second set of criteria for the same field in a second criteria row, the system will use an '''OR''' to select the records. For example:
{| borderclass="1" cellpadding="5wikitable"
|+
!Field!!Title
* Select all the records where the title is equal to President '''OR''' starting with the letters '''VP'''.
{| borderclass="1" cellpadding="5wikitable"
|+
!Field!!Title!!Last Name
* Select all the records where the title is equal to President '''AND''' where the last name starts with '''A''', '''OR''' any last name, with a title starting with the letters 'VP'.
{| borderclass="1" cellpadding="5wikitable"
|+
!Field!!Title!!Last Name