slowness

  • Thread starter Thread starter dudess
  • Start date Start date
D

dudess

first off, ty dwayne for your quick reply to my earlier
query. i tried that (removing the pages reference)to
make my report generate faster, but it doesn't help.

i just tried making a new report with the query chosen,
in design view, and didnt add any fields, and it STILL
took almost a minute and a half to open.

any other ideas on improving performance of a report
based on a complex query?

any help will be greatly appreciated
 
Do you have controls that can grow? Are there subreports? Do you use code in
the report? Are there combo boxes, listboxes, graphs, etc on the report?
 
before i even add any fields at all to the report, it is
slow to show from design view to report view.

ultimately, the underlying query is complex, and
evaluates dates in 9 fields to see if they are between
two input fields on an open form. the query runs quickly
and displays the results in datasheet view very timely.
the report is a different story, however.

i am pretty knowledgable about access, but not
programming, so i have no code in my database at all. it
is all queries and tables. one macro, to open a form
from a click on a menu, and the automatic "event
procedures" created by using wizards to make buttons, but
nothing involving the report.

and, as i said earlier, it is happening with no fields at
all, from a new report, created in design view and based
on the query.

thanks again for your efforts
dudess
 
The only other solution I can think of is to use your query to create
temporary table(s) to base your report on.
 
ty again duane.

i tried making the query into a make table query, and now
that is really slow to run too. do u think i should make
a few different tables from the info and pull it together
some other way? what is the prob?

is there some other way i can do what i want using
programing?

any ideas of direction would be much appreciated.

thanks
 
duane--just thought i would let u know...i created a
macro that ran a delete query to empty my table
called "report data", then ran a query to append the
fields from my original query, then opened the report
based on the "report data" table. this runs very quickly
and accurately. thanks for your push in that direction.
 
Back
Top