Outputting reports in excel

  • Thread starter Thread starter guidop12
  • Start date Start date
G

guidop12

I was wondering if anyone can help me with a problem I'm having. I realize
that outputting a report to excel is not the ideal way to go, but I have no
other way to get the information needed to excel. My problem is when I run
the report my columns line up as so:
seq1 comp1 total reve1 category seq2 comp2 total reve2

But when I output the report to excel the columns come over as:

comp1 total reve1 category seq2 comp2 total reve2 seq1

If someone has a qick fix, I would appreciate it.
Thanks
 
guidop12,
I recently set up some labels for a client with FullName, Address, City,
State, Zip
The client also wanted to export the labels to an Excel spreadsheet, but
wanted discrete values for Title, FirstName, LastName for a mail merge
project in Word.
I ended up adding those 3 fields just before the actual label address,
and that's the way the columns went to Excel...
Title, First, Last, FullName, Addr1,.. etc.

When I moved the 3 fields to after the label fields, it came out in
Excel as...
FullName, Addr1,City........ Title, First, Last

Ergo... it would appear Excel uses the order on the report.
That may not establish an iron clad rule, but it's just what I
experienced.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
I actually found out to to correct it, in my case anyway. You need to top
align the
detail section labels. My first label (seq1) was off a hair from the second
label, but once I align it, it came over in excel fine.
 
Back
Top