View Single Post
  #1  
Old May 27th, 2010, 09:51 PM posted to microsoft.public.access.queries
Steve Stad
external usenet poster
 
Posts: 89
Default Blank Fields in NOT Null Query Criteria

Why would a few blank fields show up in a query where I am using 'Is Not
Null' in the criteria. The rest of the Nulls are filtered out - but there
are 7 blank fields showing up. I went in to the table and hit delete in each
of the 7 fields but they still show up in the query results.