C
ctc
I am trying to create a view of outlook contacts filtered to contain the
"Client" category, but not the "Xmas Residential" and not the "Xmas Business"
categories.
I have entered the following code into the SQL tab of the view's filter
utilizing the Advanced tab and defining the criteria as either "contains" or
"doesn't contain" and then on the SQL tab checking the "Edit these criteria
directly" box and changing "OR" to "AND" between each of the criteria:
("urn:schemas-microsoft-comfficeffice#Keywords" LIKE '%Client%' AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Xmas Residential' AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Xmas Business')
The resulting view shows all contacts containing any one or more of the
categories which is not what I wanted.
Please advise.
"Client" category, but not the "Xmas Residential" and not the "Xmas Business"
categories.
I have entered the following code into the SQL tab of the view's filter
utilizing the Advanced tab and defining the criteria as either "contains" or
"doesn't contain" and then on the SQL tab checking the "Edit these criteria
directly" box and changing "OR" to "AND" between each of the criteria:
("urn:schemas-microsoft-comfficeffice#Keywords" LIKE '%Client%' AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Xmas Residential' AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Xmas Business')
The resulting view shows all contacts containing any one or more of the
categories which is not what I wanted.
Please advise.