sub report not showing up when empty

[Alkaline]

My database has a table of Persons, and each person can have any number of Events associated with them.

My problem when creating a report is that the report only lists people who have 1 or more Events associated with them. If the person has no events associated with them, they don't show up at all in the report.

What do I need to look for or do to make this work?

 

[KeithG]

Are you joining the Persons table with an events tables? Are you using an inner join or outer join? It sounds like an inner join.

 

[Alkaline]

hm, I didn't know about join types until now. I tried changing it to both of the outer joins, but it didn't seem to change it. Right now I have the relationship type set to 'One to Many' and the join type set as

Include ALL records from 'Person' and only those records from 'Event' where the joined fields are equal.

 

[KeithG]

does the query return the desired results?

 

[Alkaline]

I guess I wasn't using the query to make the report. I made a new query and a subsequent report and it works. Must have been the outer-join that did it.

Thanks