View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seth[_4_] Seth[_4_] is offline
external usenet poster
 
Posts: 1
Default 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