G
Guest
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.
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.