Be careful with UNION queries. Limited to 50 SELECT subqueries and VBA doesn't like UNION queries. I had to redesign a procedure to eliminate reliance on UNION query.
Crosstab query with multiple values producing ambiguous outer joins
VIP
Windows XP 
Access 2010 32bit
Be careful with UNION queries. Limited to 50 SELECT subqueries and VBA doesn't like UNION queries. I had to redesign a procedure to eliminate reliance on UNION query.
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.
ambiguous outer joins
Multiple outer joins - error message
Ambiguous Outer Join Error
Posting Permissions
Reply With Quote