Prev: Parameter queries
Next: match values
From: E-mail report using Lotus Notes rather t on 1 Apr 2010 20:27
Hi,

I am trying to use the iif function for laboratory values. Basically I have
lab value with number and alphabets. I want all the values with an alphabet
from A to Z to state "N" or negative and if it is a number value then leave
it as is (no change). Below is an iif function I am trying to create
maricles with. Please help. Thanks.

TEST: IIf([lab_value]=like"*[A-Z]*","N")
From: John W. Vinson on 1 Apr 2010 21:45
On Thu, 1 Apr 2010 17:27:01 -0700, E-mail report using Lotus Notes rather t
<EmailreportusingLotusNotesrathert(a)discussions.microsoft.com> wrote:

>Hi,
>
>I am trying to use the iif function for laboratory values. Basically I have
>lab value with number and alphabets. I want all the values with an alphabet
>from A to Z to state "N" or negative and if it is a number value then leave
>it as is (no change). Below is an iif function I am trying to create
>maricles with. Please help. Thanks.
>
>TEST: IIf([lab_value]=like"*[A-Z]*","N")

Try

IIf(IsNumeric([Lab_value], [Lab_value], "N")

Note that the IIF function takes *three* arguments - you gave it two - and
that the = operator and the LIKE operator are two different choices; you can't
use both together.

--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Parameter queries
Next: match values