Dynamic reports export to excel: headings problems

[celineusa]

Hi All:

I have a report that is dynamically generated: the user, via a form,
can choose the column he wants, and then generate the report and export
it to excel. On my report, each column is named lblField1, lblField2,
lblField3,... and the data tbField1, tbField2,...
Now, when I am in the form and I choose my columns, the report is
generated properly, exactly the way that I want it (the headers are
correct: Last Name, First Name, SSN,...).
When I export it to excel, the headers get the lblField1... names. Is
there any way to have them keep the name of the column that the user
selected (Name, SSN,...)?

Does anybody have any ideas?

Thank you,
Celine

 

[Duane Hookom]

Consider implementing the very simple query by form applet found at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH Query By Form'.
Users select fields, sorting, grouping, criteria,... and can easily send the
results to multiple formats including Excel.