I've just spotted a potentially infuriating facet of access comparison. Apparently, when executing a comparison expression (=, >, <, <> etc), the returned value is null if one of the two operands is null. This is thoroughly useless if you have a table in which you need to perform operations on only the records that have a null value in a certain field. Does anyone know how to compare a null value with a value and get True or false, rather than null?