Changes

Specifying Multiple Criteria in Reports

27 bytes removed, 13:37, 15 January 2016
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
2,004
edits