Display results with count of 0

[jbickl]

Hello,

I have a report which pulls from two tables. The first table is the "main" table, and the second table has multiple records which link with 1 record in the main table. The report displays data from the main table and then counts the number of records from the second table for each of the main table's records. This part works fine. The problem is that those main records which have no corresponding records in the second table do not show up in the report at all.



I don't want to have to put in a "dummy" record in the second table in order for the main record to show up in this report. Any ideas?

Thanks!

[aytee111]

Change the join of the two tables in your query - show all records from table a regardless of whether it finds matching records in table b or not.

[jbickl]

Thanks! Much appreciated.