IF

[Guest]

Hi.

I'm using the condition "If" to name my patients. IF they were born before
xxx they are XXX if not they are ZZZZ. Althoug i have 3 conditions and i
can't do it.

Help please

 

[Guest]

DateEXPR:
IIf([DateOfBirth]<#01/01/2006#,"xxx",IIf([DateOfBirth]>#01/01/2006#,"yyy","zzz"))


Change the 01/01/2006 to what you want

 

[Svetlana]

If Date<xxx Then
The Patient's Name=XXX
Else
The Patient's Name=ZZZZ
End If

 

[Guest]

Tnks my friend

Portugal 3 -2 England
--
Nelson Silva


"Wayne-I-M" escreveu:

DateEXPR:
IIf([DateOfBirth]<#01/01/2006#,"xxx",IIf([DateOfBirth]>#01/01/2006#,"yyy","zzz"))


Change the 01/01/2006 to what you want


--
Wayne
Manchester, England.

Hi.

I'm using the condition "If" to name my patients. IF they were born before
xxx they are XXX if not they are ZZZZ. Althoug i have 3 conditions and i
can't do it.

Help please

 

[Guest]

Tnks my friend

Portugal 3 -2 England