View Single Post
  #2  
Old April 13th, 2010, 05:00 AM posted to microsoft.public.access.tablesdbdesign
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default count the nulls in a report calculation

I think you mean text boxes rather than label boxes. To count the number of
records in a report section where the RSVPDate is null, you add a text box
in the Group Header or Footer with a control source of:
=Sum(Abs(IsNull(RSVPDate)))

--
Duane Hookom
MS Access MVP


"Rose" wrote in message
...
What is input into the label boxes to all count those fields within a
grouping that a blank. The Category is RSVPDate
--
Rose