Changes

Jump to: navigation, search

Using Wildcard Criteria in Reports

437 bytes added, 16:12, 30 August 2013
no edit summary
* '''_''' matches a single character. It can be used in any position in the character string. Like 'N_W%’
1. Display the '''[[Report Builder]]''' window.
2. Set the '''criteria''' for the first column to be '''Like ‘A5’<nowiki>'A%'</nowiki>'''.
[[Image:Reps35.png]]
<pre>LIKE concat('%',???,'%')</pre>
[[Image:Reps27.png]]{| border="1" cellpadding="5"|+!Field!!Criteria!!Meaning|+|Last Name||Like '%son'||Last names ending in the string "son"|+|Last Name||Not Like '%son'||All last names, '''except''' those ending in the string "son"|+|Title||Like 'VP%'||Titles beginning with the string "VP"|+|Title||='President'||Titles exactly matching the word "President"|+|City||Like 'N_w%'||Will return "New York", but not "Norwalk"|} 
{{PrevNextStart}} [[Setting Text Criteria – Logical Operators in a Report]]
{{PrevNextMid}} [[Using Sounds Like Criteria in Reports]]{{PrevNextEnd}}
[[Category:Reports]][[Category:Criteria]]
Arthur Lathrop
8,849
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/13770...18323’

Navigation menu