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!