Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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

    > >
    > >
    > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page