Thanks Roger. When you say indexing the tables, you basically mean create
relationships using the manager or simply create a primary key in the table?

Roger Carlson wrote:
It depends an awful lot on things you haven't mentioned. Indexing, table
size, the construction of the queries, etc.

My first suggestion is to check that the table is indexed properly. Any
field that participates in a join, sort, or where condition is a candidate
for indexing.

If that doesn't help, you can make your 4 subform queries into MakeTable
queries, base the subforms on the temp tables created, and run them before
you run the report. You can do this all in code (say in the click event of
a button) to make sure the queries are run before the report is opened.

I developed a report and it takes literally 30 minutes to open up. How do I
improve performance. The data set is a local table that is not on the back
[quoted text clipped - 5 lines]
lot
quicker?