Union Query 1

[IANGRAND]

Is there a limit to the number of records that can be merged though a union query?

Currently i have the following error occuring:

"System Resource Exceeded

 

[dhookom]

I don't think there is an issue with the number of records. When you get an error executing a query it is helpful to post the SQL so we can see it. You might want to try use "UNION ALL" rather than "UNION". I have hit limits on the number of UNIONs in the query.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[NightZEN]

dhookom,

thanks for this post - I was running into limits using a Union qry in a db recently upgraded to SQL Server. Using UNION ALL solved my problem. Have a Star!!


Greatefully,
-Keith