Solved

export report to excel

Posted on 2015-02-11
2
106 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
Comment Utility
If the totals are in another section , they may not.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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.

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now