Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Unanswered: Nested IIF Statements

    In MS EXCEL, I can nest "IF" statements such as, "= If(A2<60,"F",IF(A2<70,"D",IF(A2<80,"C",IF(A2<90,"B ","A"))),"")

    Can this be done in MS ACCESS? If so, how???

  2. #2
    Join Date
    Apr 2002
    Posts
    168
    You can use IIF instead, I usually use it in my query. Hope this helps.

  3. #3
    Join Date
    May 2002
    Posts
    37
    It would look like:

    IIF ([A2]<60,"F",IIF([A2]<70,"D",IIF([A2]<90,"B","A"))),"")

    Assuming [A2] is a filed in your table or query....

Posting Permissions

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