Getting hung up---Help!!!!

[wwiSports]

I am trying to create a report that is based on a querry that is based on another querry, that is based on another querry, that is based on a table----and the system keeps getting hung up ie: "Not Responding" is this because I am using to many querries? I would hope that for the moment I do not have to create a table and base the report off the table. Is there any way that I can stop it without making a table? I'm running Version 97 here (I wish 2000 like I use at home)

Beth

 

[jdegeorge]

Do you really need so many queries?

If you do, then why not make a set of these queries that are of the MAKE TABLE version so that the final query doesn't have to wait for queries 1 through 3 to complete before executing.

However, without seeing the SQL behind each query and knowing exactly why you're doing it this way, I can't be more specific.

Either try the MAKE TABLE suggestions or paste the SQL here for each of your queries, including the format of your tables.

Hope this helps.

Jim "Get it right the first time, that's the main thing..."