Counting Date/Time fields

A

Anneg

I have a report bound to a table where I would like to include an unbound
text box which counts the number of Date/Time fields that do not contain a
value. Would appreciate assistance.
Thank you
Anne
 
W

Wayne Morgan

Place a textbox in the detail section. Set its Control Source to

=IsNull([NameOfDateField])

and set its Running Sum property to Over All.

In the report footer, place a textbox and set its Control Source to

=Abs([NameOfTextboxAbove])

If desired, you can set the Visible property of the textbox in the Detail
section to No. The reason for the Abs is that the first control source will
return True or False. Access considers True to be -1 and False to be 0.
 
D

Duane Hookom

I would use a text box with a control source of:
=Sum( Abs( IsNull([YourDateField]) ) )
 
A

Anneg

Yep, you've done it again Duane. I love you guys.
Anne

Duane Hookom said:
I would use a text box with a control source of:
=Sum( Abs( IsNull([YourDateField]) ) )

--
Duane Hookom
MS Access MVP
--

Anneg said:
I have a report bound to a table where I would like to include an unbound
text box which counts the number of Date/Time fields that do not contain a
value. Would appreciate assistance.
Thank you
Anne
Click to expand...
Click to expand...
 
Top