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

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?
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Make one final list from four sources 1
Weigh tasks 0
Working on birthday "book" for my wife and having layout/editing trouble 0
How can the font and size of (all) citation numbers be altered? 1
Query performance Access 2007 1
Formatting multiple headings on a document 1
Top 5 by group 0

Top