Conditional formatting expression is (1 Viewer)

reidhaus

Registered User.
Local time
Today, 06:04
Joined
Dec 18, 2007
Messages
23
Need help, please, with writing an expression. Goal is to have the text field on report highlighted when the value of that text field reaches 90% of another field on same report.

My Access "Reference" book is as helpful as a hernia.

I've tried typing in >([Qty Projected]*[.9]) a variety of ways but can't get it right.

Any assistance in solving this dilemna will be graciously appreciated.;)
 

vbaInet

AWF VIP
Local time
Today, 11:04
Joined
Jan 22, 2010
Messages
26,374
Field Value Is >= [Qty Projected] * .9

Don't put square brackets around the .9
 

Users who are viewing this thread

Top Bottom