G
Guest
Access 2003
I have a table with Fields "Country" & "App Received Date"
My Query uses the "Group" Function & "Count" Function for the field "Country"
and "App Received Date" as the criteria using the "Where" function.
The intention is to query which country received how many applications
during the specified period. - This works well - However, the query only
renders the countries that have a value, I need to show the countries with
Null values as well.
I tried =Null, Is Null, Is Not Null, "" etc and no luck.
Any advise on how to achieve this is appreciated
I have a table with Fields "Country" & "App Received Date"
My Query uses the "Group" Function & "Count" Function for the field "Country"
and "App Received Date" as the criteria using the "Where" function.
The intention is to query which country received how many applications
during the specified period. - This works well - However, the query only
renders the countries that have a value, I need to show the countries with
Null values as well.
I tried =Null, Is Null, Is Not Null, "" etc and no luck.
Any advise on how to achieve this is appreciated