problem with the IIF(Eval expression

[sichilaba]

hI

Please Someone help me



The expression below is returnming the #Name

IIf(Eval([rating1] between F and H and [TEXT379] Between A and H)),"Repeat","Proceed")

What could be the problem?

Thank you in advance

[CJ_London]

eval evaluates a text expression e.g.

eval("22 * 45")

it looks to me like

a) you don't need the eval function and
b) the expression needs to structured properly (use of quotation marks, you have superfluous brackets and between is not a vba operator (only SQL), use >= and <= instead or a different function such as instr or in)

something like - to demonstrate different ways

IIf([rating1] in ("F","G",H") and instr("ABCDEFGH",[TEXT379])>0,"Repeat","Proceed")