records total expressions not working

  • Thread starter Thread starter pittypat12
  • Start date Start date
P

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.
 
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
'====================================================
 
A Boy Named Sue?
--
Dave Hargis, Microsoft Access MVP


John Spencer said:
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.
Click to expand...
Click to expand...
 
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
..

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


John Spencer said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top