Howo to Report empty records in sub report along with filled ones

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which is basically a list of names and addresses. In a linked
table, there is space for each person to incur expenses (single or multiple).
I'm trying to get a report of ALL the names and address, whether they have
expenses attributed to them or not. I can get a report by using the wizard
of either all the names and addresses or all the expenses.

When I try to use the wizard to get a report of all the names, addresses,
and their expenses (even if they have no expenses), the report only shows the
names and addresses associated with expenses.

How do I get it to show everyone, regardless of their expenses?

The Expenses information is in a table separate from the Names and addresses
table.

Thanks,
Dave
 
You need to open the query the report is based on and change the join to a Left
Join or Right Join.

If you see the join line between the two tables, double click on it.
Select the option which will give you ALL the records in the people table and
only ... in the expense table.
Click OK
Run your report, if you get the wrong results try clicking on the join line again.
 
Thanks for responding.

This worked very well. I tried a Left Join instead of Inner Join and
everything came out as expected. I had gone on to try a subreport before I
read your post, and that worked fairly well, though this method is a bit
neater.

Thanks,
Dave
 
Back
Top