Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2006

Tip: Looking for answers? Try searching our database.

Automation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mbynoe - 06 Dec 2006 15:41 GMT
Is it possible to have the totals in a report to automatically populate into
an Excel cell?  I have a report that has 2 totals that I need to auto-
populate into an excel form.  

Thanks!

Signature

Marion Bynoe

Andy6 - 06 Dec 2006 23:25 GMT
*****************
Normally totals on a report are created in dummy text boxes in the footer of
the report and sum the value fields above for showing or printing.
The data on the report comes from an inbuilt query behind the report and
therefore has field names that can be exported to Excel, but the dummy text
boxes cannot.
So create the totals fields within the query and export them from there to
the relevent Excel cells.
Good Luck....A.
*****************

> Is it possible to have the totals in a report to automatically populate into
> an Excel cell?  I have a report that has 2 totals that I need to auto-
> populate into an excel form.  
>
> Thanks!
mbynoe - 07 Dec 2006 17:34 GMT
Thanks!

>*****************
>Normally totals on a report are created in dummy text boxes in the footer of
[quoted text clipped - 12 lines]
>>
>> Thanks!

Signature

Marion Bynoe

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.