Soundsmith
Programmer
How can I get the results of a TRANSFORM query into a pre-existing table? (Access 2000)
I have tried this:
The TRANSFORM as a stand-alone query works perfectly, but Access doesn't want the INSERT and TRANSFORM in the same SQL statement.
Thanks in advance. David 'Dasher' Kempton
The Soundsmith
I have tried this:
Code:
DoCmd.RunSQL "DELETE * FROM tblServRpt"
strSQL = "INSERT INTO tblServRpt TRANSFORM Sum([tblBySsn].[cost]) AS SumOfcost SELECT [tblBySsn].[serv_code], Sum([tblBySsn].[cost]) AS [Total Of cost] FROM tblBySsn GROUP BY [tblBySsn].[serv_code] PIVOT [tblBySsn].[serv_date];"
DoCmd.RunSQL strSQL
The TRANSFORM as a stand-alone query works perfectly, but Access doesn't want the INSERT and TRANSFORM in the same SQL statement.
Thanks in advance. David 'Dasher' Kempton
The Soundsmith