Adding a field (Unbound field) that adds a group of numbers

[DontKnow]

Hi Guys,

I can't remember how to add a group of numbers in a report that shows the
total for a group of Total numbers. The field is an unbound textbox that
shows the total cost over three weeks ie. Textbox 28 = [Rent] * [No of
weeks]. (This works great in the detail section of the report)

When I try to add all of the Text28's in the footer section of the report via
Text44 = Sum([Text28]) I get an Input box asking the value of Text28?

How do I add an unbound text box??

Please help me!!

Cheers,

 

[Allen Browne]

Repeat the expression:
=Sum([Rent] * [No of weeks])

 

[KARL DEWEY]

You have to use the orignal fields --
= Sum([Rent] * [No of weeks])

 

[DontKnow]

Thanks Guys,

That fixed my problems

cheers,

Repeat the expression:
=Sum([Rent] * [No of weeks])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi Guys,

I can't remember how to add a group of numbers in a report that shows the
total for a group of Total numbers. The field is an unbound textbox that
shows the total cost over three weeks ie. Textbox 28 = [Rent] * [No of
weeks]. (This works great in the detail section of the report)

When I try to add all of the Text28's in the footer section of the report
via
Text44 = Sum([Text28]) I get an Input box asking the value of Text28?

How do I add an unbound text box??

Please help me!!

Cheers,

.