Hi,
I have a query which is based on 2 tables.
There are 28 columns in the query, 24 of which are calculations using fields in the 2 tables and 1 of which is a d-look up.
I had 1 link between the 2 tables and the query runs very quickly, however, when I add another link it takes AGES (currently at 5minutes and still counting) to run.
The 2nd link drops the number of records the query has to display from a hunge number (20,000 or something) to around 150. I don't understand why it takes to long to run!
Any ideas?
I have a query which is based on 2 tables.
There are 28 columns in the query, 24 of which are calculations using fields in the 2 tables and 1 of which is a d-look up.
I had 1 link between the 2 tables and the query runs very quickly, however, when I add another link it takes AGES (currently at 5minutes and still counting) to run.
The 2nd link drops the number of records the query has to display from a hunge number (20,000 or something) to around 150. I don't understand why it takes to long to run!
Any ideas?