Need to show info even when related table has no data. (Access 2010/2013

[RALJ]

Im teaching my self access, its been rough. I would like to create a report that would really impress my supervisors, i just started at the company. I'm trying to create a call action plan, so i'm recording clients information on one table, and meetings we have had with each respective client on another table. Some clients will have multiple meetings, some few, and some none. I have a relationship set between them from the client's id number on the client table to the ClientID on the meetings table. one to many. When I go to create the report, only the clients with meetings show up on the report, I would like client info to always show up on the report and meeting info to only show up under each respective client when it exists. I have worked out how to shrink and hide any text box without any info on it. It just seems like the existence of a meeting dictates where the client will show up at all in the report. Thanks everyone :banghead:

 

[pbaldy]

Edit the join between tables in your query by double clicking or right clicking on the join line. The appropriate choice should be obvious. If you're unsure, post the SQL of the query here.