[AccessD] Exporting from an Access Report to Excel

[Brad Marks]

All,

I resorted to creating a new Query with Group-By on several fields.  This worked nicely as expected.

I was just curious why sometimes exporting from an Access report works correctly and sometimes it does not.

The fact that Microsoft has provided an easy way to export from an Access report to Excel lead me to think that this would result in consistent results... silly me  :-)

Brad 



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Friday, October 28, 2016 12:07 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Exporting from an Access Report to Excel

Are your users just doing a print preview then Export to Excel?  If so, is the missing column generated by some kind of summary or calculation?  I've had problems in the past with this.

I freaked out the first time one of my users presented me with an Excel spreadsheet that had 'missing data'.  I couldn't figure out where the spreadsheet had come from in my database until the user pointed out the Export to Excel option.  I didn't even know it existed!  When this happens, I try to get the users to let me build a query which generates the correct data and give them a button which exports it properly.

Doug

On Fri, Oct 28, 2016 at 9:55 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> I assume when you run the query a la carte you see the data in the 
> mission column?  And you're using TransferDatabase?
>
> I'd try deleting all of the fields from the query except the missing 
> field and see if that field then exports. If so, then something about 
> the deleted fields may be hosing the export. If not then...we'll think 
> of something else. :)
>
> Rocky
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Brad Marks
> Sent: Friday, October 28, 2016 9:28 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Exporting from an Access Report to Excel
>
> All,
>
> I know that it is best to export from an Access   *query*   to Excel.
>
> However, I have a couple Access   *reports*   that a user would like in
> Excel.
>
> One report exports to Excel very nicely.
>
> The second report will export to Excel, but the data in one of the 
> columns is missing.
>
> I am curious as to why this happens.  Are there any guidelines on 
> exporting Access reports to Excel?
>
> I cannot understand why most columns export nicely, but one column 
> does not.
>
> Thanks,
>
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com