UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Expression for conditional formatting    
 
   
cbetts75
post 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?!
Go to the top of the page
 
+
MrSiezen
post Sep 21 2006, 07:51 AM
Post #2

UtterAccess Ruler
Posts: 2,196
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?
Go to the top of the page
 
+
cbetts75
post 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?
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 11:25 AM