Question : vba ado ace sql alias ignored for calculated column
Answered by : daniel-ferry
'For a field alias to work and appear as a column name in the recordset
'the ENTIRE calculation MAY NEED TO BE held within PARENTHESES:
SQL = "SELECT ((age + fare) / 2) as [Nonsense] from Titanic"Source : http://academy.excelhero.com/ | Last Update : Sat, 02 May 20