Jan 27 2010, 12:55 AM
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?
Jan 27 2010, 01:03 AM
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?
Jan 27 2010, 01:14 AM
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.
Jan 27 2010, 01:35 AM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here