1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

changing a number in a field if greater than a number

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

  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.
    SEMrush
     
    mfred, Feb 4, 2011 IP
    SEMrush
  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