changing a number in a field if greater than a number

Discussion in 'C#' started by mfred, Feb 4, 2011.

0
  1. #1
    I have an ASP form with a series of calculation fields that result in a field called QuotaAttained. I need that field to remain as is for the user but need it to dump into another field called QuotaAttainedCalc to continue with some calculations. That is not the problem. The problem that I have is that I need QuotaAttainedCalc to drop to 200 if the number from QuotaAttained is greater than 200. I have not done that before so I could use some help. Thanks in advance.
     
    mfred, Feb 4, 2011 IP
  2. longcall911

    longcall911 Peon

    Messages:
    1,672
    Likes Received:
    87
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Quickest way is to leave the calculations as they are and add as the last step:

    If QuotaAttained > 200 Then QuotaAttainedCalc = 200
    Code (markup):
     
    Last edited: Feb 5, 2011
    longcall911, Feb 5, 2011 IP
  3. prptl709

    prptl709 Guest

    Messages:
    83
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If you have possible then please give me reply with code for that.
     
    prptl709, Feb 25, 2011 IP