S
Sreedhar
Hi,
I'm using the DCount function with a date and a text criteria.
intTask = DCount("EventType","tblEventRecording","EventType = 'Private' AND
FollowUpDate = #" & dtDate & "#")
The tblEventRecording has a field "EventType" and another field
"FollowUpDate". I want to count all the Events of a particular "Type" (such
as 'Private' in the above line of code) and on a particular date.
I'm getting the value if I omit the date criteria, hence my guess is that
the Date Criteria is where the problem is. But, I'm unable to get it right.
Can somebody please tell me where I'm going wrong ?
Thank you.
I'm using the DCount function with a date and a text criteria.
intTask = DCount("EventType","tblEventRecording","EventType = 'Private' AND
FollowUpDate = #" & dtDate & "#")
The tblEventRecording has a field "EventType" and another field
"FollowUpDate". I want to count all the Events of a particular "Type" (such
as 'Private' in the above line of code) and on a particular date.
I'm getting the value if I omit the date criteria, hence my guess is that
the Date Criteria is where the problem is. But, I'm unable to get it right.
Can somebody please tell me where I'm going wrong ?
Thank you.