none
Concatenate for Empty Column in VBA RRS feed

  • Question

  • This Access query returns 4 columns of data: 

    SELECT CHAMBERS.TESTNO1, CHAMBERS.CUSTNO, CHAMBERS.MODEL, "" AS Empty1 FROM CHAMBERS

    How can I run this same SQL Statement in VBA as:

    Dim strSql As String
    strSql = "SELECT CHAMBERS.TESTNO1, CHAMBERS.CUSTNO, CHAMBERS.MODEL,"...

    Thanks.

    Wednesday, June 6, 2018 8:25 PM

Answers

  • I solved this myself.

    strSql = "SELECT CHAMBERS.TESTNO1, CHAMBERS.CUSTNO, CHAMBERS.MODEL, " & """""" & " As Empty1 FROM Chambers "

    Thanks everyone.

    • Marked as answer by WSNash Wednesday, June 6, 2018 9:32 PM
    Wednesday, June 6, 2018 9:32 PM