sum of records in a report 1

[oilandgasadmin]

I have a report of registrants (First, Last name, etc.) for an upcoming meeting. I have been attempting several expressions to total the # of registrants in the footer of the report. None have worked so far. I have tried:

=sum([LastName]) and count(*) in addition to many others.

Can you tell me what expression I use to just to total the number of records (or registrants) at the bottom of my report?

Your help would be immensely appreciated.

Thank you,

Linda

 

[dhookom]

You should be able to use:
=Count(*)
Make sure this text box is in the Report Footer and not the Page Footer.

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]

 

[oilandgasadmin]

Duane --

Thanks! It worked. So glad you mentioned that my expression needed to be in the Report footer - rather than the page footer!