error

[alxw3 via AccessMonster.com]

i use a query which is based on another query. i get "system resource
exceeded". 2003 version.

 

[Gina Whipp]

alxw3 ,

Sounds like your query is opening ALOT of tables but I am guessing here...
If you think that is not the case, you should post the SQL of those queries
for us to take a look at. Also, if you open the query that is a part of the
other query do you get that message?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[alxw3 via AccessMonster.com]

trying to join the queries 1 - 7 to get the output:
Query1:
BD dp T T1
B 1 Ta 6
B 2 Tb 3
B 3 Tc 2
Query2:
BD dp T T2
B 1 Ta 7
B 2 Tb 1
B 3 Tc 8
Query3:
BD dp T T3
B 1 Ta 9
B 2 Tb 10
B 3 Tc 81
Query4:
BD dp T T4
B 1 Ta 11
B 2 Tb 6
B 3 Tc 5

Query5:
BD dp TV T5
B 1 Tr 4
B 2 Ts 7
Query6:
BD dp Tv T6
B 1 Tr 14
B 2 Ts 6
Query7:
BD dp Tv T7
B 1 Tr 14
B 2 Ts 5

Output:
BD dp T T1 T2 T3 T4 Tv T5 T6 T7
B 1 Ta 6 7 9 11 Tr 4 14 14
B 2 Tb 3 1 10 6 Ts 7 6 5
B 3 Tc 2 8 81 5

 

[John W. Vinson]

trying to join the queries 1 - 7 to get the output:
Query1:

Please do as Gina suggested. Don't open the *DATASHEET* of the query; that's
useless to us without knowing the structure of your table. Instead open the
query in design view and select View... SQL. Post the SQL text here. It may
look like Ancient Sanskrit at this point, but Gina or manyh other folks here
can read it with ease.