G
Guest
Good afternoon,
I'm trying to exclude results returned by a query. I have a field which
has the following values: Released, On hold, Maturity A, Maturity B and
Maturity C.
I wish to exclude all the records where the value = Maturity *. As such I
added 'Not Like "Maturity*"' as the criteria for this field. To my amazment,
instead of eliminating these records the query returns only those values.
For fun I removed the "Not" in the criteria and I get the exact same records
returned???
How can I exclude the "Maturity*" records? Why isn't my Not Like criteria
acceptable?
Thank you,
Daniel
I'm trying to exclude results returned by a query. I have a field which
has the following values: Released, On hold, Maturity A, Maturity B and
Maturity C.
I wish to exclude all the records where the value = Maturity *. As such I
added 'Not Like "Maturity*"' as the criteria for this field. To my amazment,
instead of eliminating these records the query returns only those values.
For fun I removed the "Not" in the criteria and I get the exact same records
returned???
How can I exclude the "Maturity*" records? Why isn't my Not Like criteria
acceptable?
Thank you,
Daniel