Slow make table query with multiple joins

[Nikesh]

Hi,

I have several tables with many fields. On each of these tables,
combinations of 4 variables gives a unique record. What I need to do is to
create a single table with all the information(variables) form each of my
tables plus some additional calculated variables. I ran a series of select
queries joining on those four variables, combining about 3 of my tables at a
time. The final two queries I tried to join on those 4 variables have about
25 variables each. Since I need to export the result of the final query, I
made my final query a make table query. This make table query however is very
slow (haven't been able to complete it yet). I also tried concatenating the
four variables to create a single unique field and used it for the join. This
is not helping me either.

Interesting part, though is that most of my select queries runs in a decent
amount of time. I however haven't been able to run them when I change them to
a make table query. Any thought on why make table queries are slow and any
idea to improve the efficiency of my queries?

Thanks.

 

[John W. Vinson]

Interesting part, though is that most of my select queries runs in a decent
amount of time. I however haven't been able to run them when I change them to
a make table query. Any thought on why make table queries are slow and any
idea to improve the efficiency of my queries?

Why do you feel that you need to run a make table query AT ALL? You can export
from a Query just as easily as from a Table. If your select queries run at a
reasonable rate, just export from the final Select query.

John W. Vinson [MVP]