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.
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Weak Access User" wrote:

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