count the nulls in a report calculation

R

Rose

What is input into the label boxes to all count those fields within a
grouping that a blank. The Category is RSVPDate
 
D

Duane Hookom

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)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top