Union query size limit?

S

Sirocco

I have a Union query with 21 union clauses, each joined by "UNION", and it
works. But when I add a 22 clause, with the same alias as the other 21, I
get a "Not a valid alias name" error and the query doesn't run. Is there
a limit to the amount of text in a union query?

Thanks in advance.
 
M

martin

I asked this question a few weeks ago... The answer is the
query when compiled cant be greater than 64k. It just so
happens at 22 with me it was 31. I had to break my query
into 2 queries.

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union Query and Field Alias 7
SUM in a UNION query 2
Union query 5
Using CheckSums to insure data integrity 5
Date Limit in Crosstab from Union query 2
Currency Format Lost in Union Query 1
Duplicates in union query 3
Union Query 1

Top