Results 1 to 3 of 3
  1. #1
    parkerjallen is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    5

    Query help. IIF Statement, a few parameters.


    Code:
    Spec: IIF(((pCon1 = "E" or "G" or "I" or "L" or "N" or "O" or "T") AND (pCon2 = "E" or "G" or "I" or "L" or "N" or "O" or "T")) OR pMode = "8" OR "9"), .3, .4)
    if pCon1 and pCon2 are any of those special letters, or if pMode is 8 or 9, I need a .3. Otherwise, I need a .4.

  2. #2
    parkerjallen is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    5
    Nevermind, damn parenthesis T.T

  3. #3
    parkerjallen is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    5
    Ok, now I cannot get another result besides .3, I can't get .4 no matter how many of the conditions fail.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. if statement in sql statement, query builder
    By 54.69.6d.20 in forum Access
    Replies: 4
    Last Post: 09-11-2012, 07:38 AM
  2. query help with parameters
    By Madmax in forum Access
    Replies: 2
    Last Post: 03-05-2012, 03:07 PM
  3. Msgbox in a query with parameters
    By seb in forum Forms
    Replies: 7
    Last Post: 07-06-2010, 05:07 AM
  4. Replies: 3
    Last Post: 07-01-2010, 07:55 PM
  5. Query NOT taking the two parameters WHY?
    By iamraja5 in forum Forms
    Replies: 7
    Last Post: 03-16-2010, 04:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums