Sum in form footer

[Richie]

I have a form which displays the result of a union query in the footer I want to use a simple text box with =Sum([Expr2]) but it won't have it any way I try. The fields are re-named AS Expr2 in the underlying SQL I can achieve the sum with a simple query but not on the form. What am I missing or is it not possible.

 

[BarkerD]

Have you added a control with Expr2 bound to it on the form? I'm not too sure, but I believe that you can only use the Sum() function on a bound control. You must use the name of the control in the Sum() function.

If you don't want the control to appear on the form, you can set its' visible propery to false.

Duane Barker

[This message has been edited by BarkerD (edited 12-20-2000).]

 

[Richie]

Yes I have tried all that but thank you for the suggestion.