records total expressions not working

[pittypat12]

I have a report wherein I would like to total the number of meeting
registrants. I enter the following expressions in a text box in the report's
footer and neither of them work.

=sum([LastName])
=count(*)

Is there something I'm missing in the Properties box?

Your help is greatly appreciated. I'm about to be slammed with so many
registrations I won't see straight and having this automated total will help
me immensely.

 

[John Spencer]

In the page footer or the report footer?

They won't work in the page footer.

And Summing a Last Name makes no sense at all. What is the Sum of John,
Susan, and Ricky?



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Guest]

A Boy Named Sue?
--
Dave Hargis, Microsoft Access MVP

In the page footer or the report footer?

They won't work in the page footer.

And Summing a Last Name makes no sense at all. What is the Sum of John,
Susan, and Ricky?



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I have a report wherein I would like to total the number of meeting
registrants. I enter the following expressions in a text box in the report's
footer and neither of them work.

=sum([LastName])
=count(*)

Is there something I'm missing in the Properties box?

Your help is greatly appreciated. I'm about to be slammed with so many
registrations I won't see straight and having this automated total will help
me immensely.

 

[John Spencer]

Perhaps 3 as in menage a trois?

I hope that the OP has an answer that solves the problem

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

A Boy Named Sue?
--
Dave Hargis, Microsoft Access MVP

In the page footer or the report footer?

They won't work in the page footer.

And Summing a Last Name makes no sense at all. What is the Sum of John,
Susan, and Ricky?



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I have a report wherein I would like to total the number of meeting
registrants. I enter the following expressions in a text box in the
report's
footer and neither of them work.

=sum([LastName])
=count(*)

Is there something I'm missing in the Properties box?

Your help is greatly appreciated. I'm about to be slammed with so many
registrations I won't see straight and having this automated total will
help
me immensely.