Results 1 to 2 of 2
  1. #1
    ZachAtaiyan is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    41

    Using a Query to Sum values depending on the criteria of an IIF


    Hello All,

    I need your help once again. I have a crosstab query that I would like to create another query from. I would like for my second query to sum only certain values that meet the criteria of another field. For example; I want it to sum all of the cost estimates for records that have a reliability score greater than 300.

    Any ideas on how I can do this? I really appreciate it!

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Not sure of your qry structure but maybe this will help.
    300: IIf(Nz([ReliabilityScore]),0>300)


    [ReliabilityScore]>300

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

Similar Threads

  1. Replies: 3
    Last Post: 12-21-2013, 03:57 PM
  2. Replies: 3
    Last Post: 07-25-2013, 05:19 PM
  3. Replies: 2
    Last Post: 05-16-2012, 04:45 PM
  4. Query criteria with values and null
    By robsworld78 in forum Queries
    Replies: 13
    Last Post: 03-27-2012, 05:44 AM
  5. Replies: 2
    Last Post: 03-04-2011, 10:12 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