Issue still unresolved. I have a date field called [calldate]. I need a pie chart that shows % of null entries compared to % of entries not null. In other words, comparing blank to none blank entries in the [calldate] field. I think because the datatype is a date and not a number data type, it is not working.
Here's where I'm at, I can create a query that counts all "Is Null" or "Not Is Null", but not at the same time since the results come from the same field.
Ideally, I want to create a query that has two columns of data for the field [calldate]: 1. Is Null total, 2. Not Is Null total. These two columns of data would be data used to draw the pie chart.
Am I going about this all wrong?
Here's where I'm at, I can create a query that counts all "Is Null" or "Not Is Null", but not at the same time since the results come from the same field.
Ideally, I want to create a query that has two columns of data for the field [calldate]: 1. Is Null total, 2. Not Is Null total. These two columns of data would be data used to draw the pie chart.
Am I going about this all wrong?
