Can we use Union to combine from more than two tables? Is there a limit on ow many?
Competent Performer
Windows 7 32bit 
Access 2010 32bit
Can we use Union to combine from more than two tables? Is there a limit on ow many?
Who is John Galt?
Windows XP Access 2007
I believe the limit is on the overall size of the query, not the number of unions, but don't quote me on that. I've done 15 or so for a specialized report.
VIP
Windows 7 64bit Access 2010 32bit
I hit a limit of 50 SELECT lines in one UNION.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Exporting single query and single report.
Posting Permissions
Reply With Quote