My OS is windows 7 and I use Access 2007. The table has a marker field which is a text type, and some of the records are marked with X. I would like to retrieve all the records that do not have an X. What is the syntax please. I tried <>X; !=X; NOT X, but they all do not work. Looks like I am having the wrong syntax. Thank u.