Exporting Report to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

When exporting a report (generated from a crosstab query) into Excel, the
resulting column heading order is not the same as in the original Access
report.

For example, in Access, the report displays Columns A B C, in that order but
in Excel, displays, Columns A C B.

Thanks in advance for everyone's suggestions!

Ed
 
Well, I couldn't figure it out. I added a new column to the existing report
and that's what threw the configuration off.

A colleague of mine suggested I redo the report from scratch so I did and
got my desired result.

Ed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab report 1
Crosstab Loosing shape 1
How to Export Gmail Emails to PST Format? 5
Excel 2007 List of Materials converted into a report by building 3
export to exce spread sheet 1
Analyze with Excel Issue 5
dynamic columns number in crosstab report 4
Export Access report to Excel 5

Back
Top