Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For example:
| Example List Box1 |
| 32578977 |
| 34562877 |
23125967 |
| I need to look up last 2 digits for my exclusion and my exclusion criteria is 77 |
| So the List Box should only show: |
| 23125967 |
for that make the list box use an expression:
if(right(yourfield,2)<>'77',yourfield)
for that make the list box use an expression:
if(right(yourfield,2)<>'77',yourfield)
Thanks!