2 tables in report

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Hi I am using 2 tables to generate a report, Main table and Address table.
They are related one to many ie many addresses to one client. Unfortunately
when I run the report on any clients that don't have an address the entire
report is blank. But it works fine for clients that have an address. What
should I do to make these fields not manditory?
 
Are you using a query to populate the report? If so open the query in design
view. Double click on the line between the two tables until a dialog box
opens. Try the second option. If that doesn't work, try the 3rd option.

What you have now is known as an Inner join. You need matching records in
both tables for a record to return. The second option is a Left join where
you can a record in the client table, but not in the address table, yet
return a record. The 3rd option would return a record if there was an
address, but no client.

If you change your query to SQL view, you can see the syntax for the
different joins.
 
Back
Top