MS Query drops column aliases on certain queries
I am having trouble with a particular query using MS Query to access an
SQL server database. The query works OK, but the alias columns are dropped and the original column headings are used instead. Column aliases work fine for other queries I have created with the same system, but this one includes multiple joins, one outer join and calculations. Is there any point in me persevering with this, or should I just resort to stored procedures? Is it the outer join, the calculations (or both) that MS Query doesn't like? Suggestions greatly appreciated! |
All times are GMT +1. The time now is 08:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com