vba ado ace sql alias ignored for calculated column

The solution for “vba ado ace sql alias ignored for calculated column” can be found here. The following code will assist you in solving the problem.

‘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”

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts