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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zero's in reports 5
How do I get rid of #Num! 7
#Num question 2
Calculated control problem 10
My warning message box wont work on calculated contols 4
Comparing calculated controls on a tab control pages 6
Calculations in a Report 3
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9

Back
Top