Queries in subreports

[NeilT123]

I have a number of reports that have subreports where the main report and the subreports are driven by nested queries. I normally use a query to identify the customer and relevant time period and therefore limit the number of records called and would use this query as the starting point for the main report and for the queries driving the subreports.

This means that when the report is generated the same query could be called on three or four times depending on how many subreports there are. Is this a good or bad practise or does it make no difference?

The reason I ask is one of the more complex reports is a bit slow to open and I wonder whether using the same query several times causes confusion.

Thanks for any advice and sorry if I haven't got the terminology correct.

 

[dhookom]

I doubt using the same query in a report and subreport would cause "confusion". The slowness might be the result of complexity of the query, improper indexing of the tables, use of Keep Together properties, using [Page] of [Pages], and others.

Duane
Hook'D on Access
MS Access MVP