mbentley Registered User. Local time Today, 00:17 Joined Feb 1, 2002 Messages 138 Dec 17, 2004 #1 Is there a maximum number of tables and/or queries that can be in a union query?
mbentley Registered User. Local time Today, 00:17 Joined Feb 1, 2002 Messages 138 Dec 17, 2004 #2 Thanks. I was able to bring 13 small queries into one, but I then need to bring 4 of these union queries into a single, which would ultimately be 52 queries. Access didn't like that.
Thanks. I was able to bring 13 small queries into one, but I then need to bring 4 of these union queries into a single, which would ultimately be 52 queries. Access didn't like that.
