[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