Hi,
I've designed a UNION query to gather a field (corresponding to a monthly rate) from 12 queries (one for each month).
The goal is to use the UNION query as a basis for displaying a graph, showing the evolution of the monthly rate througout the year.
To do so, I've UNIONed the field [Rate] from 12 independent queries (maybe there is a more elegant way to go for the same result, but this is the only one I could think of).
No problem there if I UNION only 11 queries (apart from the executing time), but with all 12, Access returns a "Out of memory" message.
Is there a limitation on the number of queries one can UNION at a time ?
Maybe I could split the UNION query in 2 UNION "sub"-queries gathering only 6 queries and then UNION them 2 ?
Any help would be appreciated...
Thanks
I've designed a UNION query to gather a field (corresponding to a monthly rate) from 12 queries (one for each month).
The goal is to use the UNION query as a basis for displaying a graph, showing the evolution of the monthly rate througout the year.
To do so, I've UNIONed the field [Rate] from 12 independent queries (maybe there is a more elegant way to go for the same result, but this is the only one I could think of).
No problem there if I UNION only 11 queries (apart from the executing time), but with all 12, Access returns a "Out of memory" message.
Is there a limitation on the number of queries one can UNION at a time ?
Maybe I could split the UNION query in 2 UNION "sub"-queries gathering only 6 queries and then UNION them 2 ?
Any help would be appreciated...
Thanks