IIF question (1 Viewer)

[Scolds]

This is easy and I think I have forgotten how

I want to return a Pass or Fail on a number being between 2 values
ie ResidualChlorineFreeAns: IIf([tblWater]![ResidualChlorineFree]>1 &<5,"Pass","Fail")

Of course it is not working

Thanks in advance

 

[Pat Hartman]

You need to repeat the fieldname and & is not a valid relational operator.

ResidualChlorineFreeAns: IIf([tblWater].[ResidualChlorineFree] > 1 AND [tblWater].[ResidualChlorineFree] < 5, "Pass", "Fail")

 

[Scolds]

Thanks

Thanks Pat,
See I knew it was easy the same as I know how I am not so good.