Subfrom without records prevents Main From record results

[libraccess]

I would have moved this question from queries but I could not see how to, I am really hoping to solve this one this weekend
Attached sample of both a one subform and two subform MainForm.
As you will see if the subform has no entry then the report will not display any results for that record.


I have a DB with a two subform form and entries are likely to be in one or the other but not both.
Unless there are entries in both nothing shows on the report.
Thanks please
looks like my r finger is quicker than my o finger, if only I could morf my froms to my forms

[June7]

Its because the report uses INNER JOIN in the RecordSource query. Use:

SELECT tblSub1.*, tblSub2.*, tblMain.DateA, tblMain.TextA, tblMain.NumberA
FROM (tblMain LEFT JOIN tblSub1 ON tblMain.ID = tblSub1.Sub1FK) LEFT JOIN tblSub2 ON tblMain.ID = tblSub2.Sub2FK;


You could edit your post to fix typos.


I did a Mod thing and moved your post to Reports but as it turns out, the issue was with the query structure. Issues are so often multi-faceted.

[libraccess]

Solved Thanks You need to be renamed to June10 as in 10 out of 10
I need to not rely on design view for queries and do a little study of SQL , right
Tried to edit my typos but the Title would not budge

[June7]

Edits like that have to be done in Advanced post editor.

Here is one site for tutorials on SQL http://www.w3schools.com/SQl/default.asp