I have a table called "Data_Inventory" with a field called "application" which I want to group by in a query. As for the remaining columns I want to return blank values that each look at a different column within the "Data_Inventory" table (e.g. # of blank values in Column D, E, F, etc.) What is the criteria selection for doing this within the query designer?

1. What data types are the columns D, E, F, etc...?

2. If they are of Text data type, do you know whether they have empty String values or Null values?

They are all the text data type and were imported from excel with some blank cells (I believe that should be Null?). I didn't know there is a difference between Null and blank strings for text.

Check the properties "Required" and "Allow Zero Length" of each of the Field and then Access Help on these 2 properties which control whether the Field value can be Null or not.

Null is different from empty String. Null is unassigned and it does not have a value or a data type. An empty already has the String data type of length zero.