Group total based on RSVP date

[Phil]

Hi,
I have two tables:
Hosts ~ contains the names of the hosts
Guests ~ contains name, count (number of people this guest is bringing) and
a RSVP date.
There is a one (hosts) to many (Guests) relationship between the tables.

I have a report with groups based on the Hosts with the guests for each host
listed within each host group. I want a "count" total after each host group
for those guests who have a date in the RSVP date field. In other words, if
there is a date in the date field, the "count" for that guest would be
included in the host total count. Those without a date, the count would not
be counted.
Your help would be appreciated and thanks.

 

[Ofer Cohen]

To include those records that doesn't have a date in them, you can try
something like

=Sum([RSVP] Is Null , 0 , 1)

So it will sum all the 1'ns that are generated when there is a date

 

[Marshall Barton]

To include those records that doesn't have a date in them, you can try
something like

=Sum([RSVP] Is Null , 0 , 1)

So it will sum all the 1'ns that are generated when there is a date

You forgot the IIf

=Sum(IIf([RSVP] Is Null , 0 , 1))

 

[Ofer Cohen]

Oops,

Thanks Marshall, I can't believe I missed that, but I assume it will
probably happen to me again.

Thanks

--
Good Luck
BS"D

To include those records that doesn't have a date in them, you can try
something like

=Sum([RSVP] Is Null , 0 , 1)

So it will sum all the 1'ns that are generated when there is a date

You forgot the IIf

=Sum(IIf([RSVP] Is Null , 0 , 1))