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

  • Thread starter Thread starter DontKnow
  • Start date Start date
D

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,
 
Thanks Guys,

That fixed my problems

cheers,

Allen Browne said:
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.


DontKnow said:
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,
Click to expand...

.
Click to expand...
 
Back
Top