/VBA/Vba ado ace sql alias ignored for calculated column

Vba ado ace sql alias ignored for calculated column

'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: academy.excelhero.com

Similar codes

20 votes482 views1 answer
Excel vba factorial
VBA
0 vote313 views1 answer
Excel vba disable copy paste
VBA
4 votes353 views2 answers
Vba last row
VBA
0 vote365 views1 answer
Excel vba first column in range
VBA
1 vote353 views1 answer
Vba optional
VBA
0 vote311 views1 answer
Excel vba formatconditions range
VBA
0 vote367 views1 answer
Excel vba add reference programmatically
VBA
0 vote348 views1 answer
Vba sort the data Z to A
VBA
0 vote297 views1 answer
How to self delete a vbscript file
VBA
0 vote336 views1 answer
Vbscript for loop
VBA