Query too slow in Report...

  • Thread starter Thread starter Lynn Pennington
  • Start date Start date
L

Lynn Pennington

This query runs very fast if you just run the query.

Same query as the Record Source - it takes for every and
sometims Access stops responding.

I have two indexes on the roadnet_site table: siteid and
deliverydays.

The JOIN is a query pulling information from the customer
table.

Any ideas on why a report using the query above take a
long time to preview.

Thanks,
Lynn.
 
I had the same problem once...what I did was run a MakeTable query using the
queries for the report, then the report would be running off the tables.
What a difference. It takes a few seconds to make the tables, but beats
waiting minutes for the queries to run. After report is closed, delete the
tables.
 
Back
Top