Changes

Specifying Multiple Criteria in Reports

598 bytes added, 13:38, 15 January 2016

no edit summary

{{SeqReportPageHeader}}

 

Before you start to use multiple selection criteria it is vital that you understand how the '''Report Builder''' will interpret the criteria. Mistakes in the construction of criteria are one of the biggest sources of confusion on '''ALL''' reporting tools.

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]]{| class="wikitable"|+!Field!!Title!!Last Name|+|Criteria||='President'||Like 'A%'|} 

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

[[Image:Reps30.png]]{| class="wikitable"|+!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'''.

==Or Between Rows==

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:

[[Image:Reps31.png]]{| class="wikitable"|+!Field!!Title|+|Criteria||='President'|+|OR||Like 'VP%'|}

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

[[Image:Reps32.png]]{| class="wikitable"|+!Field!!Title!!Last Name|+|Criteria||='President'||Like 'A%'|+|OR||Like 'VP%'|||}

* Select all the records where the title is equal to President '''ORAND''' any title starting where the last name starts with the letters VP '''ANDA''' Last Name beginning with the letter , '''AOR''' regardless of any last name, with a title starting with the titleletters 'VP'.

[[Image:Reps33.png]]{| class="wikitable"|+!Field!!Title!!Last Name|+|Criteria||='President'||Like 'A%'|+|OR||Like 'VP%'||Like 'A%'|}

* Select all the records where the title is equal to President '''OR''' any title starting with the letters VP '''AND''' Last Name beginning with '''A'''.

 {{PrevNextStart}} [[Using Sounds Like Criteria in Reports]]{{PrevNextMid}} [[Prompting for Criteria in Reports]] {{PrevNextEnd}}  [[Category:Reports]][[Category:Criteria]]

• ← Older edit

Alvin Thompson

2,004

edits