I have a table with 6 fields. the last field is text field and has Required =No. There is some data in the field and some blanks. When I do a query with WHERE field6<>'XXXXX', it filters out 'XXXXX' as well as all the blanks. HOw do I get it to just
filter out 'XXXXX' and leave the blanks?