+ Reply to Thread
Results 1 to 2 of 2

Access Query Criteria_Plz Fix

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    73

    Access Query Criteria_Plz Fix

    Hi..

    I am trying to fix this formula. Could anyone help me in this regards.

    NewRate: IIf(([General Code]=755526 Or 755527) And ([UC]="0217" Or "0215" Or "0210" Or "0106" Or "0221"),0,[TOTAL COST QAR AVG RATE])

    I need to get value "0" in case of general codes 755526 and 755527 and if UC values = 0217,0215,0210,0106,0221. Or else I need to get TOTAL COST QAR AVG RATE

    Please help me!

    Thanks in advance!

    :-)

  2. #2
    Registered User
    Join Date
    02-23-2014
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Access Query Criteria_Plz Fix

    Guys I fixed it !

    IIf(([General Code]=755526 Or [General Code]=755527) And ([UC]="0217" Or [UC]="0215" Or [UC]="0210" Or [UC]="0106" Or [UC]="0221"),0,[TOTAL COST QAR AVG RATE])

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing Access query into Excel:Microsoft Query
    By ge0rge in forum Excel General
    Replies: 3
    Last Post: 04-02-2009, 10:51 AM
  2. Can I use MS Query in Excel like an Append Query in Access
    By Sam Wardill in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 09:45 AM
  3. [SOLVED] Access query to excel and back to access updated??
    By jwr in forum Excel General
    Replies: 0
    Last Post: 03-19-2006, 08:50 PM
  4. Database Query-a query that reads data from MS Access
    By Osmar Mateus in forum Excel General
    Replies: 4
    Last Post: 01-29-2006, 04:10 PM
  5. Run Access query from Excel, input value to query being value in c
    By Nagesh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2005, 10:10 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1