[AccessD] Exporting report to excel

I recently ran into an issue when I was trying to export a report's
underlying query to Excel.  The catch is that the report had a dynamic
filter which is not taken into account when exporting from the
underlying query (the query exported more data to Excel than the Report
was showing, due to the filter on the report)

A number of people here in AccessD offered some nice ideas on how to
deal with this.

It looks like your situation is different, however.   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
Sent: Friday, September 17, 2010 3:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
-- 
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.