SQL UNION ALL problem after using UNION ALL more than 10 times
- by VBGKM
I'm getting a formatting problem if I use more than 10 UNION ALL statements in my VBA Code.
If I use 10 or less everything works great.
What I'm trying to do is combine 12 worksheets (Excel 2007).
I have a numerical column called SC that turns into string and date if I have more than 10 UNION ALL. If I try to use ROUND with more than 10 UNION…
