Results 1 to 3 of 3
  1. #1
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63

    Why Main Report doesn't show a record if subreport has no record

    I have a subreport linked with the main report but the main report does not display the record (of parent table) if subreport has no data.
    I have already used LEFT JOIN in the query on which the main report is based on.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,371
    the report query is prob. inner join and wont show parent if parent record has no subrecords.
    To see ALL parent records with or without children, the query must be an OUTER join query.

  3. #3
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63
    Thanks ranman256, I was missing LEFT JOIN again in the query. LEFT JOIN solved the problem, but still INEER JOIN clause exists in the query, and it's working (showing all records from parent query)

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

Similar Threads

  1. Replies: 2
    Last Post: 03-05-2017, 11:10 AM
  2. Replies: 2
    Last Post: 02-04-2016, 08:13 AM
  3. Replies: 20
    Last Post: 05-19-2015, 05:10 AM
  4. Subreport doesn't show all the records properly
    By jesustain in forum Reports
    Replies: 2
    Last Post: 10-10-2014, 03:02 PM
  5. Replies: 1
    Last Post: 04-15-2013, 10:02 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