Count records in subreport and add to main report count 1

[dawnd3]

Hi there, I hope this is possible. I have a report listing people who have rsvp'd to an event. Their name is in the memberID header and in the detail section is the name of the guests that they have invited. (this is so the guest name will fall under the member who invited them.) In the report header I have a text box with:

=Count([MemberID]) & " people registered for this event."

This only counts the members but I want it to add in the guests from the subreport. Please tell me how to revise this formula.

Thanks,

Dawn

http://www.calliopeconsulting.net

 

[dhookom]

You can create a totals query that groups by MemberID and counts guests. Add this query to your main report's record source query and join the MemberID fields. Then add the Count of Guests to your field list. You can then sum these directly in your main report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[dawnd3]

Duane, thank you so much. I was confused at first but I kept reading it over and over and did it one step at a time and it worked. Thanks!!!

Dawn

http://www.calliopeconsulting.net