I have a table with three columns.
Column one is my customer's name
Colum two is the yearly sales to this customer for 2003
Column three is the yearly sales to this customer for 2004
I use a form that adds / edits the records in the table.
I have added a text box to the form and called it +/- %
and gave it this expression =sum([2003]/[2004]) and that works but not the way I need it to.
What I need is (maybe) a different expression that would return the following results:
example 1 : 2003 = $100 ..... 2004 = $200 ..... +/-% = +100%
example 2 : 2003 = $100 ..... 2004 = $50 ....... +/-% = -50%
The + or - in the returned value in +/-% are desired but if this is a problem a red negative and black positive are OK too.
Can someone help on this problem ?
Would it be easier to use a query and have a "calculated" column in the query to do the math for the +/-% ?
If yes how do I do this ?
Thank you
Column one is my customer's name
Colum two is the yearly sales to this customer for 2003
Column three is the yearly sales to this customer for 2004
I use a form that adds / edits the records in the table.
I have added a text box to the form and called it +/- %
and gave it this expression =sum([2003]/[2004]) and that works but not the way I need it to.
What I need is (maybe) a different expression that would return the following results:
example 1 : 2003 = $100 ..... 2004 = $200 ..... +/-% = +100%
example 2 : 2003 = $100 ..... 2004 = $50 ....... +/-% = -50%
The + or - in the returned value in +/-% are desired but if this is a problem a red negative and black positive are OK too.
Can someone help on this problem ?
Would it be easier to use a query and have a "calculated" column in the query to do the math for the +/-% ?
If yes how do I do this ?
Thank you