469,887 Members | 1,275 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,887 developers. It's quick & easy.

subquery acting up

I'm using access 2000 and with assistance thought I had this problem

This query works:
SELECT Q3.id, Q3.date, Max(Q3.Rank) AS Ninetieth
FROM query3 AS Q3
WHERE (((Q3.Rank)<=(0.9*(SELECT COUNT([*]) FROM query3 as Q3A WHERE
(Q3A.ID = Q3.ID) AND (Q3A.[date] = Q3.[date])))))
GROUP BY Q3.id, Q3.date;

This query locks up Access, "action will reset current code in break
SELECT Q3.id, Q3.medate, Max(Q3.meRank) AS Ninetieth
FROM qry90th1 AS Q3
WHERE (((Q3.meRank)<=(0.9*(SELECT COUNT(*) FROM qry90th1 as Q3A WHERE
(q3.ID = Q3A.ID) AND (q3.[medate] = Q3A.[medate])))))
GROUP BY Q3.id, Q3.medate;

They're both based on the same query, one is query3 and the other is
just a renamed copy of query3. The query3 returns a [rank] for
individual [results] grouped by [id] and [date]. Query3 returns only
31 records, so this should be a quick query.

Any suggestions to why the subquery would cause Access to lockup? I
thought it was just my computer, because I got the first query to work
on another computer, after having the same problem.


Nov 23 '05 #1
0 1093

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by lev | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.