[AccessD] Exporting report to excel

I have the command on the ribbon. It is the same as the export to  
excel on the quick access toolbar.

Debbie

Sent from my iPhone

On Sep 17, 2010, at 2:01 PM, "Brad Marks" <BradM at blackforestltd.com>  
wrote:

> Debbie,
>
> Which Access command or technique are you using to export the report  
> to
> Excel?
>
> Brad
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
> Sent: Friday, September 17, 2010 12:53 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Exporting report to excel
>
> I am exporting a report to excel from access 2007. This report has the
> detail section not visible and is only showing data in a group footer.
> I have discovered that the data will not show up at all unless I have
> some aggregate function in those text boxes (last and sum have worked
> well). My only issue is that a date field is always exporting as
> 1/0/1900. I have tried lots of different aggregation functions as well
> as appending a string to the end and using cstr() to see if that will
> work. All of my efforts so far yield blanks or 1/0/1900. Any other
> ideas?
>
> Debbie
>
> Sent from my iPhone
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>