Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Add item to a select statement
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Add item to a select statement
Resolved · Medium Priority · Version 2007
Reply Fri 25 Feb 2011, 13:52Delegate Tracey said...
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.
For upcoming training course dates see: Pricing & availability
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
Thu 10 Mar 2011: Automatically marked as resolved.
|