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.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"mrPela" u59877@uwe wrote in message news:a7a66efa10fae@uwe...
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
end of the database. However there are about 4 sub forms on the report.
These
subforms are all queries. I requery the subform queries prior to opening
up
the report. What are some things that I can do to make this report open a
lot
quicker?