IIF question

Scolds

Registered User.
Local time
Today, 18:31
Joined
May 19, 2004
Messages
15
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
 
Thanks

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

Users who are viewing this thread

Back
Top Bottom