SCMON Access SQL Pivot error

[Dassudt]

Sub SQLtest()
Dim Dbe As DAO.Database
Dim Qr As DAO.QueryDef
Dim qdfTRANSFORM As DAO.Database
Dim pSQL1 As String

Set Db = CurrentDb
DoCmd.TransferText TransferType:=acImportDelim, TableName:="Dept1", _
FileName:="C:\Users\Sindhu\Desktop\SC\Dept1.Txt", HasFieldNames:=True
pSQL1 = "TRANSFORM Sum(Amount) as TGeek SELECT Hospital, SUM(Amount) as Total FROM GeeK Group BY Hospital PIVOT COBID IN (COB, CODD, COI)"
pSQL1 = "Select Emp1.EmpName, Dept1.DeptNo FROM Emp1 INNER JOIN Dept1 ON Emp1.DeptID=Dept1.DeptID"
End Sub


"Getting error on the above code"

 

[Macropod]

Duplicate of: https://www.mrexcel.com/forum/microsoft-access/1005259-scmon-access-sql-pivot.html
Dassult: Kindly read the board policy against posting duplicates of the same question, in Rule #12 - http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Thread closed.