HOW TO TOTAL UNBOUND CONTROL ON A FORM 1

[villica]

On the Open even of the report, I have bind the controls to a table

all the controls are on the detail section

example
qty1 qty2 qty3
1 66 22
99 66 2


how do I add a subtotal
I tried = sum(qty1), but it does not work

any suggestions



villica

 

[villica]

I meant to say report not FORM

villica

 

[LittleSmudge]

A a new text box control beside qty1 and also bind it to the field qry1 but call it Tqry1 and make it Visible = No

Then set the Running Total property to OverGroup ( or Over All - if appropriate - see the Help file on the difference )

Then in the Report Footer add a text box and call it GTqty1 and set the ControlSource = Tqry1


Tat will do it.


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[villica]

Thank you LittleSmudge. it worked.

villica