Displaying calculations on forms

[Knackers]

Hi,

I have a query with an expression in it to calculate days. I want to be able to sum the values of this expression and then display them on a form. Any ideas?

Obviously I will have to set the control on the form to an expression, but I think that I having trouble with the syntax.

The query name is: Leave01
The expression that I wish to sum is: Expr1

The best I could come up with was

=Sum([Leave01]![Expr1])

If anyone could help me out with this expression, I would be most grateful.

Cheers

 

[dneufarth]

set the control source of the form to the query - Leave01

set the control source of the control to Expr1


Dave