Selection Formula for specific Address

[kwoo7706]

I have created a report that will only display addresses where the address field is blank or contains the word "approval" (i.e. 1 Pre Approval St).

I have attempted to use the following selection criteria: {PROPERTY._StreetAddress} like ["", "%approval%"]

All the addresses that are blank display, and the addressses containing "1 Pre Approval St" do not.

How can I adjust this formula to also display the addressses containing "approval"?

Thanks for your help!

 

[lbass]

You should be using asterisks "*", not "%" (except in a command).

-LB

 

[kwoo7706]

Thank you so much, that worked!