M
Mark D. Hall
I have a database of customers that I call and want to add a "Never Call
Again" field for customers that no longer need to be contacted. I would
rather use a text field instead of a yes/no, but am having a problem with my
query.
I thought I could simply use "< > "N"" in the criteria field to display all
customers that don't have an "N" in the "Never Call Again" field, but no
customers at all show when I have it set that way. It works fine if I use
"Is Null," but I'm nervous to use that in case I accidentally type something
else in that field because it will no longer be null and not show that
customer.
Is it possible to sort like this? Thanks.
Mark
Again" field for customers that no longer need to be contacted. I would
rather use a text field instead of a yes/no, but am having a problem with my
query.
I thought I could simply use "< > "N"" in the criteria field to display all
customers that don't have an "N" in the "Never Call Again" field, but no
customers at all show when I have it set that way. It works fine if I use
"Is Null," but I'm nervous to use that in case I accidentally type something
else in that field because it will no longer be null and not show that
customer.
Is it possible to sort like this? Thanks.
Mark