Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data in first column drops off when printing from Excel to Adobe . | Excel Discussion (Misc queries) | |||
column aliases dropped with database query | Excel Programming | |||
column aliases dropped with database query | Excel Discussion (Misc queries) | |||
MS Query imbedded Queries | Excel Programming | |||
Locating Query Errors in a Sea of Queries | Excel Programming |