Count total of a field add to the end of my report

A

Angela

I know this is so simple because I used to know hoe to do it. i have a
report where I have a list of people invited to an event. All i need is to
have a total of the "Invited" field show at the end of my report.
 
K

Kris

Go into Design view. Add a sperate field for the "total"
Right click int he field and click on properties. You will then chose
"Control Source"
Click the button all the way to the right. Then it will bring up the
expression builder. Just click on the table that you eant to pull the info
from.
 
K

Ken Sheridan

I assume the Invited field is a Boolean (Yes/No) field. If so add a text box
to the report footer with a ControlSource of:

=Sum(IIf([Invited],1,0))

The IIf function returns 1 for every row where Invited is True, 0 where its
False, so by summing the values the result is in effect a count of the Trues.
 
A

Angela

Thanks Kris. I did not quite understand your answer but you lead me to be
able firgure out how to do it. I added a text field where I just put
=Count(invited) at the report footer.
 
Top