I have a report that joins 3 tables, I would like to have all informant from table 1 and 2 even there is no information in table 3.
If I set the join to Left Join, a blank record from table 2 and 3 will also be printed.
When you defined the query how did you define the join or link between table 2 & 3?
If you cretaed a query for the report, open the query designer (or data source of the report), select the link (the line) between table 2 & 3 and you should see a dialog pop up showing 3 options. Change the link to all from table 2 and table 3 where matched. precise wording will vary (Its too early to start work here yet to check Access). From memory this will be the second radio button.
In essence you can modify the way the joins are performed int hequery designer very easily, as opposed to writing the SQL directly.
you need to alter the join criteria - the easiest wya to talk you through it is through the query designer. Alter the link between table2 & table 3 so that it includes all rows from table2 that match the criteria AND all rows from table 2 where they match table 3 (like I said radio button 2 on the pop up dialog)