[AccessD] Exporting from an Access Report to Excel

[Rocky Smolin]

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