Plesae Help: Names of columns are repeated when I export to Excel

[Tetol]

Hello- I have Access 2007.

My report has a subreport in it and when I export the report to Excel, each time the records in the subreport is more than one page, Excel displays the column names again.

This does not look good. How do I stop the column names from repeating in excel.

The subreport is also in the detail section of the main report, below the records of the main report.

Thank you in advance.

 

[lameid]

Generally speaking you should export a table or query to excel and not a report. That way you will get the data in a table layout you expect.

 

[SkipVought]

Ditto!!!

I absolutely detest getting a 'report' in Excel. What a waste! Hang the perp by the thumbs! Put your report in a pdf and send it to a VP.

Send me a TABLE in Excel, that I can work with!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Tetol]

Thanks folks.

My next question is how do you export a table/query to excel by just the click of a form button?

Can you set this up using a macro?

Thanks again?

 

[Tetol]

Sorry, I should refine my question below.

My original report has a subreport in it. The main report and subreport are based on two different tables. The reason I wanted to export the report to excel is so I would have the records from the two tables in one file.

So I cannot export one table because there are two tables involved here and I need data from both tables in the same excel file.

Thanks for your help again.

 

[SkipVought]

JOIN the tables in a logical way in a query and EXPORT the resultset.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]