Add multiple Detail Section

kbreiss

Registered User.
Local time
Today, 18:17
Joined
Oct 1, 2002
Messages
228
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
________
Breakup advice dicussion
 
Last edited:
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.
 

Users who are viewing this thread

Back
Top Bottom