Report Offensive Message

Access SQL
If you build a query in Access and put 'Is Not Null' in the criteria row under the field you want to exclude nulls, Access builds the SQL statement like this:
SELECT Fee_Account
FROM tbl_Account
WHERE (((Fee_Account) Is Not Null));

Not saying the other way won't work, but this does and seems to make sense. I don't know if it proper or not.
Posted by jkowolf
22nd Nov 2006