Number of Unions in an Access query? 1

[vbSun]

Is there a limitation for the number of unions that can be used in an MS Access query?

I have a query with about 21 unions, which returns only 4 records. Any idea what is causing this?

I am using MS Access 2003.

Any help is appreciated.

------------------------------------------
The faulty interface lies between the chair and the keyboard.

 

[Golom]

I think it's 50 but I'm not certain about that.

Would need to see the code and a sample of the data. Only 4 records from 21 UNIONs isn't necessarily a problem if many of them are filtering out all records so that they return nothing.

Also ... if you're using UNION rather than UNION ALL, SQL will filter out duplicate records so you may have more than 4 being returned but they are duplicates.

 

[vbSun]

Thanks Golom,

UNION ALL Worked!

------------------------------------------
The faulty interface lies between the chair and the keyboard.