By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Exporting access report to Excel with all data

P: 23
I have a report that I built in Access 2002. I built it with the report wizard, but then went into design mode and added a extra information which was calculations off the existing fields in the report (these calculated values are not pulled in the original query). So the report looks great and performs as expected, but when I export it to Excel I lose all of the extra fields that I added (and of course all of the formatting). All that it exports is what was originally created in report wizard. Is there any way to get the rest of the report, that I worked so hard on creating, over to Excel? After reading the previous posts on the limitations of the report export I'm expecting the worst but hoping for the best. Thanks.

Oct 31 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,072
I wasn't aware that calculated fields aren't passed to the Excel formatted save 0f a report. That the formatting and drawings like lines, boxes, etc. are lost is a known fact.
You could try to lineup the calculated fields with the other exporting fields, as sometimes fields are "lost" when the export doesn't know where to place the result.

I must however admit that I always do calculations in the query, thus the totalling in grouplevels will always be possible. Why can't you "move" the calculations ?

Nov 2 '07 #2

P: 23
The calculations that I'm performing are somewhat complex and the intermediate steps are to be shown on the report. For example, in the detail section I have a row for each employee and the columns headings are days of the week with overtime hours worked on those days populating it. I can perform simple calculations like summing them up, and that will move over to excel, but not more complex calculations like finding out what percentage of all overtime for the week was worked on Tuesday. For that I have to divide one field by another, and access doesn't export those.

I tried moving the fields around to see if they were lost because of where they were located, but it didn't make a difference. For now, I just told the users that these reports are to look at and not to export to excel and manipulate. If they want something more (the reason for the manipulation in excel) they should tell me and I will add the fuctionality to the database. That seems to suffice for now, but I'm still bothered by the apparent limitation that access has placed on exporting data to a program in it's own family!!
Nov 10 '07 #3

Expert 2.5K+
P: 3,072
I concur with that :-)
The basic appproach I use is to use the "plain" query data and transport that to excel. The calculations are than added using the excel formula. When the number of rows is fized, then a template excelsheet can be used holding the calculations and using automation the cell ranges can be filled.

Nov 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.