Non Numeric

[John]

Hello,

I have three text boxes in the header section of my report. The 3rd one
(Text58) is suming the other two text boxes (=[Text51]+[Text54]). In my
report Footer I'm trying to add up all the results of the 3rd box. In the
control source of my footer I have =sum(Text58). I don't get any results??
any Idea?? Thanks.


John

 

[Larry Linson]

Those built-in functions do not work on Calculated Controls, only on Fields
in the Record Source, but you should be able to accomplish what you want
with:

= Sum([Text51]+[Text54])


Larry Linson
Microsoft Access MVP

 

[John]

That doesn't work. Let me try explaining again.

In the header section of the report I am adding to control source fields and
dividing it by a total in another field. The result is in percentage format.
It works great. Now I'm trying add up all the percentages in the header
section to be displayed in my footer. That's where things go wrong. I'm not
getting the result.

Those built-in functions do not work on Calculated Controls, only on Fields
in the Record Source, but you should be able to accomplish what you want
with:

= Sum([Text51]+[Text54])


Larry Linson
Microsoft Access MVP

Hello,

I have three text boxes in the header section of my report. The 3rd one
(Text58) is suming the other two text boxes (=[Text51]+[Text54]). In my
report Footer I'm trying to add up all the results of the 3rd box. In the
control source of my footer I have =sum(Text58). I don't get any
results??
any Idea?? Thanks.


John

 

[Larry Linson]

"John" wrote

In the header section of the report I am
adding to control source fields and
dividing it by a total in another field. The
result is in percentage format.
It works great. Now I'm trying add up
all the percentages in the header
section to be displayed in my footer.
That's where things go wrong. I'm not
getting the result.

You cannot use the builtin Sum function on Calculated Controls -- that does
not work.

Because events may fire more than once, and how many times they may fire is
not necessarily obvious, accumulating totals in event code can be
problemetical.

Can you possibly do a Sum on the calculations you are performing in the
Header? Maybe something like:

= Sum(([Field1] /[Field2])*100)

If you can create an expression that does what you want using Fields in the
Record Source, that is likely to work.

Larry Linson
Microsoft Access MVP