[AccessD] Exporting from an Access Report to Excel

[Doug Steele]

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
>