Prev: Linking forms and reports.
Next: Make Table v. Append to Table: Need Some Expert Design Inputs
From: Rose on 12 Apr 2010 23:39
What is input into the label boxes to all count those fields within a
grouping that a blank. The Category is RSVPDate
--
Rose
From: Duane Hookom on 13 Apr 2010 00:00
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" <Rose(a)discussions.microsoft.com> wrote in message
news:707464D4-405C-4F4A-BD0E-0036E7CA5337(a)microsoft.com...
> What is input into the label boxes to all count those fields within a
> grouping that a blank. The Category is RSVPDate
> --
> Rose

 | 
Pages: 1
Prev: Linking forms and reports.
Next: Make Table v. Append to Table: Need Some Expert Design Inputs