Thank you for looking at my post.
I am creating a report that excludes certain domain names. I have several domains now and will be adding additional excluded domain names in the future.
I can get the select statement to work by entering a line for each domain name. Here is what I use now (works correctly):
NOT ({DomainAddress} LIKE "DELL*") AND
NOT ({DomainAddress} LIKE "YAHOO*") AND
NOT ({DomainAddress} LIKE "APPLE*")
But it seams that you should be able to use something like (this example does not work):
NOT ({DomainAddress} LIKE "DELL*","YAHOO*","APPLE*"
Here is my question:
Can someone give me the correct syntax for a formula with multiple "not like" fields so I do not need to enter the line over and over?
Thank you,
Richard Scott