mdnuts
Registered User.
- Local time
- Today, 12:11
- Joined
- May 28, 2014
- Messages
- 131
Hi folks,
I'm having a moment - I just can't seem to get this one to work right. I've got the following query. I need to count the number of Null dates or show zero if there are no Null Dates.
Which is just counting the number of dates so far. It got me to thinking I need to do something like this.
Which pops a "cannot have aggregate function in expression" error.
Any ideas?
I'm having a moment - I just can't seem to get this one to work right. I've got the following query. I need to count the number of Null dates or show zero if there are no Null Dates.
Code:
SELECT DISTINCTROW qryNoticeResponseNew.fldNoticeID, Count(qryNoticeResponseNew.[fldResponseSeen]) AS fldCount
FROM qryNoticeResponseNew
GROUP BY qryNoticeResponseNew.fldNoticeID;
Code:
SELECT DISTINCTROW qryNoticeResponseNew.fldNoticeID, IIf(IsNull(qryNoticeResponseNew.[fldResponseSeen]),1,0) AS fldCount
FROM qryNoticeResponseNew
GROUP BY qryNoticeResponseNew.fldNoticeID;
Any ideas?
Last edited: