justagrunt
Technical User
- Oct 10, 2002
- 132
- 0
- 0
Hi,
Due to lack of system resources (the system will allow result of 11 queries but not the full 15 to be joined) I have had to create two union queries (one of 9 and the other of 6 ) to generate the information I require. The two unions can be run separately but a one off proved to be too complex, hence I broke it up into two.How do I go about joining these two, so that the combined information can be exported to a final destination of an Excel spread sheet latter.
I have thought of a make table but the two Union queries have the same field names.
Thanks
Regards
Bill
Due to lack of system resources (the system will allow result of 11 queries but not the full 15 to be joined) I have had to create two union queries (one of 9 and the other of 6 ) to generate the information I require. The two unions can be run separately but a one off proved to be too complex, hence I broke it up into two.How do I go about joining these two, so that the combined information can be exported to a final destination of an Excel spread sheet latter.
I have thought of a make table but the two Union queries have the same field names.
Thanks
Regards
Bill