Need headers placed IN the table

[newcoder54]

I have a query which has a cross tab query as its source. So the "fields" change often. I want my query to just pull the field names and put them into a table. Over my head.

 

[danvlas]

Open a recordset based on:
Select * From YourCrossTab

Then...

For Each fld in rst.Fields
DoWhateverYouWantWith fld.Name
Next

would be a start...

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Zion7]

Try the TransferDateabase Method, set "with data" property
to True/False (I forget)...

Will create new table based on Query/Table, with option
to include/not include data.