My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Expression for conditional formatting
|
|
 Sep 21 2006, 04:05 AM
Post
#1
|
|
|
UtterAccess Member Posts: 23  |
Hi,
Would some one be able to assist me in creating an expression for my report – Query name = QRY_TotalReturnRate_ByModel2 Field = Total Return Rate Criteria If the resulting percentage is greater than 0% but less than 5% = Green font If the resulting percentage is greater than or equal to 5% = Red font I’m sure this really simple but it does not seem to work when I just use the ‘Field Value Is’ option so I presume an expression is required. Please help?! |
 |
 
|
|
Sep 21 2006, 07:51 AM
Post
#2
|
|
|
UtterAccess Ruler Posts: 2,198 From: Den Bosch - Netherlands |
You should be able to format that with the field values. What do you mean with is does not seem to work?
Is it always red? What did you enter as field values? |
|
|
|
|
Sep 21 2006, 08:04 AM
Post
#3
|
|
|
UtterAccess Member Posts: 23 |
Hi,
It does not recognise my criteria and then just keeps the font as the original setting. I’ve just tested ‘Field Value is’ ‘less than or equal to’ ‘5’ and selected the font to be green. Obviously I also tried as a decimal (0.05) but that does not work either. Any ideas? |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 02:09 AM |