Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: access report question

    I have the following calculated field on a report

    =IIf([field1]/100>0,[field1]/100,0)

    It works great. How can I have this field peak at a specific number. For example anything that reaches "112" will be brought down to "95" while still using all the rules in the code above? Can I put two of these IIf statements in there somehow?

  2. #2
    Join Date
    Aug 2002
    Location
    Québec, Canada
    Posts
    109
    Yes, you could change

    =IIf([field1]/100>0,[field1]/100,0)

    To

    =IIF( IIf([field1]/100>0,[field1]/100,0) >=112,95,IIf([field1]/100>0,[field1]/100,0))

    The problem is that the formulas is evaluated twice

    JefB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •