ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   DAO query/recordset returns with field names (https://www.excelbanter.com/excel-programming/274659-dao-query-recordset-returns-field-names.html)

Seth[_4_]

DAO query/recordset returns with field names
 
How do i change this code to return the field names on
top of the recordset returned from the SQL statement?

Sub tri4()
'
' tri4 Macro
' Macro recorded 8/18/2003 by smanchik
'
Set dbs = OpenDatabase("P:\SManchik\Loss Triangles\Loss
Triangles.mdb")
Set qry = dbs.CreateQueryDef("tri5", "TRANSFORM Sum([105 -
(b)].[5]) AS SumOf5 SELECT [105 - (b)].qtr AS AQ FROM
[105 - (b)]GROUP BY [105 - (b)].qtr PIVOT [105 -
(b)].order")
Set rst = qry.OpenRecordset()
[b9].CopyFromRecordset rst
dbs.QueryDefs.Delete "tri5"
dbs.Close

'
End Sub


All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com