Welcome to SPN

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

Sign Up Now!

IIF Expressions

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

  1. Mike Mc1981

    Mike Mc1981
    Expand Collapse
    Guest

    Hi,

    I've written an expression that says when Tracking Database = Yes, RAG
    Status = Red (text). I need to extend this expression so that when Tracking
    Database = No, RAG Status = Green and when Tracking Database = Maybe, RAG
    Status = Amber

    Can anyone help

    The expression so far is....

    =IIf([Tracking Database]="Yes","Red")


    --
    Mike Mc1981
     
  2. Loading...

    Similar Threads Forum Date
    India IIFA 2014: ‘Bhaag Milkha Bhaag’ wins 9 technical awards! Breaking News Mar 5, 2014
    Cultural Appropriation And Expressions Of Sikhi Convert's Corner Dec 28, 2015
    Expressions of Faith Mixing Two Worlds Sikh Youth Sep 1, 2009
    One truth, many expressions Hard Talk Mar 15, 2008

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    =IIf([Tracking Database]="Yes","Red", IIf([Tracking
    Database]="No","Green",IIf([Tracking Database]="Maybe","Amber","????")))

    However, you might consider building a table that maps from Tracking
    Database value to RAG Status, and join that table to your other table.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Mike Mc1981" <MikeMc1981@discussions.microsoft.com> wrote in message
    news:67CF298D-4E6E-4D3A-A3F4-32037050A2BD@microsoft.com...
    > Hi,
    >
    > I've written an expression that says when Tracking Database = Yes, RAG
    > Status = Red (text). I need to extend this expression so that when

    Tracking
    > Database = No, RAG Status = Green and when Tracking Database = Maybe, RAG
    > Status = Amber
    >
    > Can anyone help
    >
    > The expression so far is....
    >
    > =IIf([Tracking Database]="Yes","Red")
    >
    >
    > --
    > Mike Mc1981
     
  4. Mike Mc1981

    Mike Mc1981
    Expand Collapse
    Guest

    Thanks for your help, however when I do this the field results in #Name?
    --
    Mike Mc1981


    "Douglas J Steele" wrote:

    > =IIf([Tracking Database]="Yes","Red", IIf([Tracking
    > Database]="No","Green",IIf([Tracking Database]="Maybe","Amber","????")))
    >
    > However, you might consider building a table that maps from Tracking
    > Database value to RAG Status, and join that table to your other table.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Mike Mc1981" <MikeMc1981@discussions.microsoft.com> wrote in message
    > news:67CF298D-4E6E-4D3A-A3F4-32037050A2BD@microsoft.com...
    > > Hi,
    > >
    > > I've written an expression that says when Tracking Database = Yes, RAG
    > > Status = Red (text). I need to extend this expression so that when

    > Tracking
    > > Database = No, RAG Status = Green and when Tracking Database = Maybe, RAG
    > > Status = Amber
    > >
    > > Can anyone help
    > >
    > > The expression so far is....
    > >
    > > =IIf([Tracking Database]="Yes","Red")
    > >
    > >
    > > --
    > > Mike Mc1981

    >
    >
    >
     
  5. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Mike

    If you have typed Douglas' answer is it is shown then you would get ?Name
    normally if either the control source contains a formula and part of this is
    no longer available and or (more likely) you have mis-spelt part of the
    formula.

    An old trick is to try and remove the table identifier from the formula
    so if you have =[Forms]![WaynesStuff]![FieldName]
    then try and use
    =[FieldName]

    Note if you are in a query you should NOT remove the identifier if the field
    has not been brought into the query - you may have only inserted the table
    into the design section at the top of the screen

    If you are not sure about field names and what can and can not be used you
    should try the Expression Builder as it will only include available items and
    will not make spelling miostakes. (with an "o")


    Hope this helps

    --
    Wayne
    Manchester, England.



    "Mike Mc1981" wrote:

    > Thanks for your help, however when I do this the field results in #Name?
    > --
    > Mike Mc1981
    >
    >
    > "Douglas J Steele" wrote:
    >
    > > =IIf([Tracking Database]="Yes","Red", IIf([Tracking
    > > Database]="No","Green",IIf([Tracking Database]="Maybe","Amber","????")))
    > >
    > > However, you might consider building a table that maps from Tracking
    > > Database value to RAG Status, and join that table to your other table.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Mike Mc1981" <MikeMc1981@discussions.microsoft.com> wrote in message
    > > news:67CF298D-4E6E-4D3A-A3F4-32037050A2BD@microsoft.com...
    > > > Hi,
    > > >
    > > > I've written an expression that says when Tracking Database = Yes, RAG
    > > > Status = Red (text). I need to extend this expression so that when

    > > Tracking
    > > > Database = No, RAG Status = Green and when Tracking Database = Maybe, RAG
    > > > Status = Amber
    > > >
    > > > Can anyone help
    > > >
    > > > The expression so far is....
    > > >
    > > > =IIf([Tracking Database]="Yes","Red")
    > > >
    > > >
    > > > --
    > > > Mike Mc1981

    > >
    > >
    > >
     

Share This Page