Results 1 to 2 of 2
  1. #1
    steven7 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    May 2016
    Posts
    13

    Query Help

    I am looking to return whichever is highest from the following;




    Expr1: [Field A]*[Field B] or [Field A]*[Field C]


    Any help appreciated.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    try

    Expr1: [Field A]* iif([Field B]>[Field C],[Field B],[Field C])

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

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