Is there a way to have multiple detail sections in a report? The reason I ask is because users want to include every facility name in the report even the though the datasource of the query include a date range. If there are no records within the date range it will not show the facility name on the report. I thought I could hard code every facility name in the report and have a detail section for each facility...is this possible?

Thanks in advance,

Kacy

Kacy

Have you tried a sub report? works just like a sub form.


Regards

Brett

No, a report can have only one detail section. Your solution is to use a query as the RecordSource for the report. Create a query that does a left join between the facility table and the query that you are currently using. You will need to leave the original query as it is because it has selection criteria that is applied to the many-side table. This selection criteria MUST be applied BEFORE the left join. If you try to do everything in a single query, you will not get the desired result.

Thanks Pat....worked great!