REPORT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my report I highlight my field--go to formatting--conditional
formatting--condition 1--expression--then I type in the following--[rKRAT>=1
& <=2] AND [nMLO >=6]
When rKRAT is [>=1 and <=2] and [nMLO>=6] I want to make that field box turn
gray. I know my formula is wrong. Can anyone tell me how to correct it.
Thanks
ed
 
In my report I highlight my field--go to formatting--conditional
formatting--condition 1--expression--then I type in the following--[rKRAT>=1
& <=2] AND [nMLO >=6]
When rKRAT is [>=1 and <=2] and [nMLO>=6] I want to make that field box turn
gray. I know my formula is wrong. Can anyone tell me how to correct it.
Thanks
ed
Click to expand...

You are confusing the Ampersand (&) with the And operator, and you are
using the brackets [] where you should be using parenthesis ().
The brackets are supposed to surround the field name.
Try:

([rKRAT] >=1 AND [rKrat] <=2) AND [nMLO] >=6
 
Back
Top