If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
records total expressions not working
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. |
#2
|
|||
|
|||
records total expressions not working
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 '================================================= === pittypat12 wrote: 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. |
#3
|
|||
|
|||
records total expressions not working
A Boy Named Sue?
-- Dave Hargis, Microsoft Access MVP "John Spencer" wrote: 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 '================================================= === pittypat12 wrote: 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. |
#4
|
|||
|
|||
records total expressions not working
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" wrote in message ... A Boy Named Sue? -- Dave Hargis, Microsoft Access MVP "John Spencer" wrote: 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 '================================================= === pittypat12 wrote: 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. |
Thread Tools | |
Display Modes | |
|
|