Hi,
How many number of query can be written in union query?
Is there any limitation i.e. say 250 query can be union together or not?

Thanks in advance.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Hi,
there are following limitation:
1) Number of enforced relationships - 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships
2) Number of tables in a query - 32
3) Number of fields in a recordset - 255
4) Recordset size - 1 gigabyte
5) Sort limit - 255 characters in one or more fields
6) Number of levels of nested queries - 50
7) Number of characters in a cell in the query design grid - 1024
8) Number of characters for a parameter in a parameter query - 255
9) Number of ANDs in a WHERE or HAVING clause - 99
10) Number of characters in an SQL statement - Approximately 64,000

Peko

all is fine ,,but didn't get anser of my query....

How many number of query can be written in union query?


Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Hi,
you are limited by number of used tables (32) in query string.
So, if you use one table per one query, then you may type 32 queries united by UNION clause.
Peko