Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to stop column names from repoeating when export to Excel

Status
Not open for further replies.
Tetol

Tetol

MIS
Dec 21, 2010
26
US
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 span 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.
 
Status
Not open for further replies.

Similar threads

GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
107
GPnew
GPnew
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
825
EwaFAMA
EwaFAMA
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
258
dhookom
dhookom
iamchemist
  • Locked
  • Question
Push To WORD?
Replies
3
Views
236
iamchemist
iamchemist
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
165
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top