Count function

[Glenn Suggs]

I need a field at a level break in a report to give me the count of all
printed records where a certain date field contains a date. When I use this
syntax in the Control Source property, I get a total count of all records.
=Count(IsDate([MyDate]))

What should it be?

Thanks in advance,

 

[Duane Hookom]

Count() will count all values whether true or false. They are all counted
except for Nulls.

Try
=Sum(Abs(IsDate([MyDate])))

 

[Glenn Suggs]

That worked great.
Thanks,
--
Glenn

Count() will count all values whether true or false. They are all counted
except for Nulls.

Try
=Sum(Abs(IsDate([MyDate])))

--
Duane Hookom
MS Access MVP

I need a field at a level break in a report to give me the count of all
printed records where a certain date field contains a date. When I use
this
syntax in the Control Source property, I get a total count of all records.
=Count(IsDate([MyDate]))

What should it be?

Thanks in advance,