Hi, I have a simple question. I wanted to count a Column containing
Dates and the word "Empty".
This is what I am trying to do.
Closed Dates
------------
4/2/2004
4/7/2004
4/9/2004
Empty
4/5/2004
7/3/2004
Empty
Empty
And come out with
Empty: 3
and in another query
Date: 5
Here is what I am attempting, but I am getting a data type mismatch
error.. I am trying to using "Empty" and Not "Empty"
SELECT Count(aparFullTable.[PTF Closed]) AS [CountOfPTF Closed]
FROM aparFullTable
HAVING (((Count(aparFullTable.[PTF Closed]))="empty"));
Thanks