Can you

[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

 

[Mark D. Hall]

Please ignore the above message. It was a mistake that got sent before
proofreading.

Mark