Changes

Specifying Multiple Criteria in Reports

154 bytes added, 16:44, 29 April 2013

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:

 

[[Image:Reps29.png]]

{| border="1" cellpadding="5"

* Select the records where the title is equal to President '''AND''' the Last Name begins with '''A'''.

[[Image:Reps30.png]]{| border="1" cellpadding="5"|+!Field!!Title!!Last Name!!First Name|+|Criteria||='President'||Like 'A%'||Like 'A%'|}

* Select the records where the title is equal to President '''AND''' the Last Name begins with A '''AND''' the First name begins with '''A'''.

If you enter second criteria for the same field in a second criteria row, the system will use an '''OR''' to select the records. For example:

[[Image:Reps31.png]]{| border="1" cellpadding="5"|+!Field!!Title|+|Criteria||='President'|+|OR||Like 'VP%'|}

* Select all the records where the title is equal to President '''OR''' starting with the letters '''VP'''.

• ← Older edit
• Newer edit →

Arthur Lathrop

8,849

edits