Problem with calcualted field in report

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

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
 
Algebraically, there appears to be nothing wrong. But Access may want you to
enclose the denominator in parenthesis. Try it and see what happens.
 
Thanks Ken did as you said but still get same message
Tony
Ken Smith said:
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 said:
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
Click to expand...
Click to expand...
 
Tony said:
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.
Click to expand...


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