Results 1 to 4 of 4
  1. #1
    Jovani is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    2

    Select by group

    Hi, good monrning!!
    How can do i a select for group for example, i have the number of delivered 1000, this number its on tree rows but whit status "delivered", "dont delivered" and "others"

    Delivered | Status |
    1000 delivered
    1000 dont delivered
    1000 others
    2000 sent


    2000 dont delivered
    2000 others

    I need to return only the delivered numbers where dont have the information "delivered"...

    Thanks!

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You can do this with a nested query, or with a set of two queries. The easiest way is with a set of two queries.
    First, create a query that ONLY returns records where the Status is "delivered".
    Then, create a new query, which is an Unmatched query between your original table and the 1st query, matching on the Delivered value.
    You can just return the Delivered field and "Group" it in order to get rid of all duplicate entries.

  3. #3
    Jovani is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    2

    Solved

    Quote Originally Posted by JoeM View Post
    You can do this with a nested query, or with a set of two queries. The easiest way is with a set of two queries.
    First, create a query that ONLY returns records where the Status is "delivered".
    Then, create a new query, which is an Unmatched query between your original table and the 1st query, matching on the Delivered value.
    You can just return the Delivered field and "Group" it in order to get rid of all duplicate entries.
    Thanks, now i got it!!

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome!

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

Similar Threads

  1. Replies: 2
    Last Post: 01-27-2016, 08:38 AM
  2. Replies: 6
    Last Post: 06-09-2015, 09:51 AM
  3. SELECT & GROUP BY Clause
    By johnseito in forum Access
    Replies: 5
    Last Post: 07-11-2014, 10:55 PM
  4. Select into with group
    By Dennis Willis in forum Queries
    Replies: 1
    Last Post: 07-08-2014, 08:23 PM
  5. GROUP by yet SELECT fields not within GROUP BY
    By johnseito in forum Access
    Replies: 25
    Last Post: 11-03-2013, 10:20 PM

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