Advanced Expression Help Needed

[dogman01]

I have a field named "value" and need it to compare itself to another field that holds its "value limit" and another field that is a "plus or minus value". I am trying to do a conditional formating that turns the "value" field to a red color if it is not withing limit guidelines. For example:
"value"=3.2
"value limit"= 3.0
"plus or minus"= 0.1
Result I would want is 3.2
The value is out of limit.

Hope I explained this right, Thanks in advance

 

[rainman89]

see this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=162496&highlight=text+color

 

[dogman01]

I get the conditional formatting part but how do you write an expression that uses plus or minus 0.2?

 

[rainman89]

so you want something like

me.value > me.[value limit]+me.[plus or minus] OR me.value< me.[value limit]-me.[plus or minus]

 

[dogman01]

I think we're on the right track but I am not sure what the "me" part means. Thanks

 

[rainman89]

me refers to the active form

 

[lala]

so you want something like

me.value > me.[value limit]+me.[plus or minus] OR me.value< me.[value limit]-me.[plus or minus]

i've had this problem before, i need this solution also

how do you say the plus or minus part?
just how you have it?
and that works?


me.[plus or minus] will work???

 

[rainman89]

i've had this problem before, i need this solution also

how do you say the plus or minus part?
just how you have it?
and that works?


me.[plus or minus] will work???

no the plus or minus was their value from their table.

the plus or minus are done with + or - in the actual code

 

[gemma-the-husky]

is this a repeat posting - in sure i already answered this

value"=3.2
"value limit"= 3.0
"plus or minus"= 0.1
Result I would want is 3.2
The value is out of limit.

assuming they are all fields then

abs([value])-[value limit])>[plus or minus]

will return true or false accordingly