/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

2 votes347 views2 answers
Excel vba if sunday or staurday
VBA
0 vote320 views1 answer
Excel vba protect content
VBA
0 vote295 views1 answer
Excel vba existence of a file
VBA
22 votes471 views1 answer
Xlvba check for folder
VBA
0 vote322 views1 answer
Vbnet hex to binary
VBA
0 vote277 views1 answer
How to self delete a vbscript file
VBA
0 vote361 views1 answer
Vbs run with cscript
VBA
5 votes890 views1 answer
Vlookup vba
VBA
0 vote315 views1 answer
Type excel.application is not defined vb
VBA
0 vote456 views1 answer
Vba array of integers
VBA