Brad Marks
BradM at blackforestltd.com
Fri Sep 17 14:01:57 CDT 2010
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.