/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

0 vote244 views1 answer
Vba format currency
VBA
0 vote235 views1 answer
Vba shape transparent
VBA
3 votes241 views1 answer
Vba make long from two words
VBA
0 vote249 views1 answer
Vba string
VBA
1 vote220 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote235 views1 answer
Vba open report
VBA
0 vote240 views1 answer
How to extract a file from an ISO:
VBA
13 votes514 views2 answers
Vba write text file
VBA
0 vote236 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote254 views1 answer
Visual stuiod not recognising desgined labels
VBA