I am using Access as a quick way to manipulate and cleanse an excel spreadsheet.

To do this I want to run several queries to remove certain data and leave me with only the data I need to check.

The problem I seem to be having is that when I create my queries and run them the results for the columns I have set the criteria on show the values I expect but also shows (Blanks). When I filter for these blanks, however, there is nothing showing i.e. all the fields in my query are empty rather than just the column I filtered for the blanks.

Is this because there is a field in the source data that could be blank? I thought when you picked fields from a table to run a query only those fields are affected by the criteria - almost as if it's a mini data set. Am I missing something?!?!?

This is what the criteria has been set as:-