Why is my Access Queries take a long time to generate?

  • Thread starter Thread starter Weak Access User
  • Start date Start date
W

Weak Access User

I used to do the query in less than 30 secs, but using the same method to do
another query, it took more than a minutes to generate the table.

Why is it so?
 
There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here.
Information on primary keys and relationships would be a nice touch too. Also
any indexes.
 
Back
Top