Tracey has attended:
Excel VBA Intro Intermediate course
Add item to a select statement
I have inherited some code and added an item to every instance of a select statement that I can see. I'm getting an error that the two sides of a union query aren't equal (there's a union all around the select statements), but can't see what I'm missing.
RE: Add item to a select statement
Hi Tracey
Thanks for the question.
A union query in Jet SQL will only work if the two tables in the union query have the same fields with identical names. That error suggests that you are trying to unite two tables that have different fields.
So as a first check, I'd look to see if that is the case. If so, then you will need to address this. If this is not the case then please get back to me and I can explore further options
Regards
Stephen
