How to Count Dates with a Criteria

[Alicia]

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(aparFullT able.[PTF Closed]) AS [CountOfPTF Closed]
FROM aparFullTable
HAVING (((Count(aparFu llTable.[PTF Closed]))="empty"));
Thanks

[dgs5150]

al******@hotmai l.com (Alicia) wrote in message news:<d3******* *************** ****@posting.go ogle.com>...

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(aparFullT able.[PTF Closed]) AS [CountOfPTF Closed]
FROM aparFullTable
HAVING (((Count(aparFu llTable.[PTF Closed]))="empty"));
Thanks

This should work for you. You can't say Count(fieldname ) = "empty"
for Count is numeric. Also this should be Where not Having

SELECT Count(aparFullT able.[PTF Closed]) AS [CountOfPTF Closed]
FROM aparFullTable
Where aparFullTable.[PTF Closed]="empty";

[Donna Sabol]

You should be using "WHERE" rather than "HAVING"

SELECT Count(aparFullT able.[PTF Closed]) AS [CountOfPTF Closed]
FROM aparFullTable
WHERE (((Count(aparFu llTable.[PTF Closed]))="empty"));

al******@hotmai l.com (Alicia) wrote in message news:<d3******* *************** ****@posting.go ogle.com>...

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(aparFullT able.[PTF Closed]) AS [CountOfPTF Closed]
FROM aparFullTable
HAVING (((Count(aparFu llTable.[PTF Closed]))="empty"));
Thanks