Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nosoyaguru

  1. nosoyaguru

    Multiple if-then-else statements

    All is well than ends well. Thanks
  2. nosoyaguru

    Multiple if-then-else statements

    Thanks, that is an excellent idea. I was begining to think in that direction but I thought I should be able to get it to work in its initial code. Assigning values to individual results maybe easier than compounding lots of IF statements.
  3. nosoyaguru

    Multiple if-then-else statements

    Sorry, it does work, but I don't know how since when I first re-coded the statement it didn't. I closed CR and re-started the report, then it worked!!! Again, thanks, I think that cheking for nulls and greater than zeroes is what did it.
  4. nosoyaguru

    Multiple if-then-else statements

    Thanks for the prompt reply. I've tried your suggestion, same results. And no, there are no cases where both PLUS & SUB or UNSUB amounts are present, its either PLUS or SUB, or UNSUB, but sometimes there are SUB & UNSUB amounts. It seems so simple (this is common programming code in other...
  5. nosoyaguru

    Multiple if-then-else statements

    Why is it that the statement below only works for the first IF condition, I can switch the statements around but only the first condition works: if ({GUARANTEE_REPORT.PLUS_CERTIFIED_AMOUNT} > 0) then "PLUS" Else if ({GUARANTEE_REPORT.SUB_CERTIFIED_AMOUNT} > 0) then "SUB" else if...

Part and Inventory Search

Back
Top