Results 1 to 2 of 2
  1. #1
    black272 is offline Novice
    Windows 10 Access 2007
    Join Date
    Dec 2021
    Posts
    5

    How to display results of parent query if sub query returns nothing


    Hello,

    Im running a query that relies on two sub queries. How do I display the results of the main query if one of the subqueries returns nothing?

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Usually use an outer join from the 1sr query to the 2nd query so it should show all records from 1st query and will be blank for those fields from the 2nd query if there are no matching records. If that is not what you are looking for maybe provide an example.

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

Similar Threads

  1. Replies: 3
    Last Post: 04-17-2019, 04:47 PM
  2. Simple query returns no results
    By jhuvba in forum Queries
    Replies: 5
    Last Post: 10-01-2018, 12:45 PM
  3. Replies: 1
    Last Post: 04-12-2012, 11:34 AM
  4. Query returns ro results
    By MichealShinn in forum Queries
    Replies: 5
    Last Post: 02-21-2012, 01:24 PM
  5. Replies: 13
    Last Post: 01-13-2011, 10:15 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