![]() |
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