I have a question about query. I'm currently working in a query. The query has 6 tables. one of the table has a field name "Notes". I want to pull all the records from this table that has Notes. I used in the criteria as "Not Is Null and <> "", I also tried Is Not Null and <>"", they both gave me error message "ODBC-Failed". I've tired "Is Not Null" but it gave me records that is empty. I'm not sure what I did wrong.