Counting Date/Time fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
I would use a text box with a control source of:
=Sum( Abs( IsNull([YourDateField]) ) )
 
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...
 
Back
Top