View Single Post
  #1  
Old May 7th, 2010, 02:53 PM posted to microsoft.public.access.reports
mrPela
external usenet poster
 
Posts: 4
Default How to Imporve Report Perfomance

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?