Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

IF

Discussion in 'Information Technology' started by ElKuryos, Jul 28, 2006.

  1. ElKuryos

    ElKuryos
    Expand Collapse
    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
    --
    Nelson Silva
     
  2. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    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.



    "ElKuryos" wrote:

    > 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
    > --
    > Nelson Silva
     
  3. Svetlana

    Svetlana
    Expand Collapse
    Guest

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

    ElKuryos
    Expand Collapse
    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.
    >
    >
    >
    > "ElKuryos" wrote:
    >
    > > 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
    > > --
    > > Nelson Silva
     
  5. ElKuryos

    ElKuryos
    Expand Collapse
    Guest

    Tnks my friend

    Portugal 3 -2 England

    --
    Nelson Silva


    "Svetlana" escreveu:

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

Share This Page