Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

export report to excel

Posted on 2015-02-11
2
Medium Priority
?
122 Views
Last Modified: 2015-02-11
I have a report in access that I want to export to excel when it does the headings come over but not the totals
0
Comment
Question by:Serena2345
  • 2
2 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40604599
If the totals are in another section , they may not.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 40604608
See the comments in this thread similar recent thread:
http://www.experts-exchange.com/Database/MS_Access/Q_28614861.html

Know that "totals" will be Hardcoded when Exported.
So users must be made aware of that.

Then standard process is to export just the data and recreate the totals in Excel...

JeffCoachman
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question