Welcome to SPN

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

Sign Up Now!

Add a Credit to Script

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

Tags:
  1. Bob

    Bob
    Expand Collapse
    Guest

    =IIf([tbOverDueAmount]>1,"Overdue Amount:",Null)
    How Can I add this to the Script <-1"Credit"

    Thanks in advance.........Bob Vance
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Bob

    You can used a Nested IIF (but the second option is better - and makes more
    sense). Use the help (F1) to learn more about Nested IIF's - you can have (I
    think) up to seven in a formula.


    =IIf([tbOverDueAmount]>1,"Overdue
    Amount:",IIF[tbOverDueAmount]<-1,"Credit",Null))

    Or

    =IIf([tbOverDueAmount]>0,"Overdue Amount:","Credit")

    Hope this helps

    --
    Wayne
    Manchester, England.



    "Bob" wrote:

    >
    >
    > =IIf([tbOverDueAmount]>1,"Overdue Amount:",Null)
    > How Can I add this to the Script <-1"Credit"
    >
    > Thanks in advance.........Bob Vance
    >
    >
    >
     

Share This Page