Problem with calcualted field in report

[Tony Williams]

Can anyone tell me what's wrong with this formula?
([Sum Of txtClients0]*[txtclientstotal])/ [Sum Of txtClientsTot]
TxtClientstotal is a calculated on the report the other controls come from a
query.
I get an error message asking for Extra "(" in the formula.
TIA
Tony

 

[Guest]

Algebraically, there appears to be nothing wrong. But Access may want you to
enclose the denominator in parenthesis. Try it and see what happens.

 

[Tony Williams]

Thanks Ken did as you said but still get same message
Tony

Algebraically, there appears to be nothing wrong. But Access may want you to
enclose the denominator in parenthesis. Try it and see what happens.

Can anyone tell me what's wrong with this formula?
([Sum Of txtClients0]*[txtclientstotal])/ [Sum Of txtClientsTot]
TxtClientstotal is a calculated on the report the other controls come from a
query.
I get an error message asking for Extra "(" in the formula.
TIA
Tony

 

[Marshall Barton]

Can anyone tell me what's wrong with this formula?
([Sum Of txtClients0]*[txtclientstotal])/ [Sum Of txtClientsTot]
TxtClientstotal is a calculated on the report the other controls come from a
query.
I get an error message asking for Extra "(" in the formula.

Strange mesage. Did you forget the = sign in front of it?