percentage expression in query

[isildad]

This is not a good day.
I have a table with two columns
2003
2004

I have a form that I use to populate the table
It has three fields: 2003...2004...and -/+%
The -/+% is a text box I've created and given the expression(I have to thank Gibbs for that)

=([2004]-[2003]/[2003]) formated to "percent" w/zero decimal
so: if I type :
in 2003 the value $10
in 2004 the value $20
in get in +/-% the value +100%

Needing a report with again a calculated "+/-%" I've created a Query based on my table and used the same "expression" but the calculation of the percentage does not work properly. ( I get 1900.00% )

Anyone knows why ?
Thank you.

 

[isildad]

Just figured it out:

=([2004]-[2003]/[2003]) should be ([2004]-[2003])/[2003]
Still if I'm wrong let me know.

 

[texasalynn]

right - remember that you need to group what needs to happen first in (). Because math doesn't happen left to right, but on the type of math function. Divide happens before subtraction.

HTH
texasalynn