IIF parameter question

  • Thread starter Thread starter BenKan Lin via AccessMonster.com
  • Start date Start date
B

BenKan Lin via AccessMonster.com

Hi,
In a report the following statement works OK,
IIF([Utfall]>[MalVarde];3;1)

My question is how to get the > or < from a field [ForOK] as a variable?

BenKan
 
Try that

eval("iif([Utfall]" & Parameter & "[MalVarde],3,1)")

The Parameter is a variable that hold the Symbol
 
Back
Top