REPORT FORMULA

[Gambler]

Im working on my report. Im in the conditional formatting and using expression. I want to be able to shade a field in my report when its value is 2 less than EPR. The formula >=([nEPR]-2) doesnt work. Can anyone help me.

Thanks ed

[Rick]

Shouldn't that be <=

[Donnie]

turn it around so it reads <=([nEPR]-2)

[Donnie]

"JINX!!!" Rick!!

[Gambler]

When I use that formula, I get the error message. The expression you entered contains Invalid Syntas. You may of entered a comma without a preceding value or identifer. Any suggestions?

[Rick]

HEY DONNIE

Your turn.

Conditional report formatting is a little out of my league. :confused:

[hurrikane]

are you sure nEPR is part of your query or report?

[Gambler]

Yes EPR is in my report.

[Donnie]

Thought I posted this last night, but it musta been in my dreams......

Ed-
You need to change the first box back to Field is....... then choose less than or equal to out of the next box....and then add this to the last box ....[nEPR]-2

Note: do not put an "=" sign in that last box....it is not an expression so it should not have an equals sign!

I could swear I posted this last night.....oh well....hope this helps!

[Gambler]

That did it.
Thanks Donnie
ed