Percentage Calculation in a Query

[molsen]

Hi All

I am trying to set up a calculation between two values to show the percentage difference. In Excel, for example, I would have two values, £905,175 and £891,563, and I would enter =A1-G2)/ABS(A1), which would then return a plus or minus percentage value. Any ideas how to do this in a query using Access 2010?

Many thanks

Mark

 

[CJ_London]

exactly the same way except use field names rather than cell id's

(field1-field2)/ABS(field1)

put an = sign before it if using as a controlsource to a form or report control

 

[molsen]

exactly the same way except use field names rather than cell id's

(field1-field2)/ABS(field1)

put an = sign before it if using as a controlsource to a form or report control

Sorry for being a numpty CJ, but I'm doing this in a query using the build button. Whatever I try I get a syntax error. The field names are [Pulse Value] - [SWFAL Mkt Value]/ABS [Pulse Value]. Ive tried it with your equation but to no avail.

Cheers

Mark:banghead:

 

[molsen]

Sorry for being a numpty CJ, but I'm doing this in a query using the build button. Whatever I try I get a syntax error. The field names are [Pulse Value] - [SWFAL Mkt Value]/ABS [Pulse Value]. Ive tried it with your equation but to no avail.

Cheers

Mark:banghead:

Sussed it! Works a treat:

([Pulse Value]-[SWFAL Mkt Value])/Abs([Pulse Value])