[AccessD] Exporting report to excel

Interesting that you would get that invalid date result. A date type
field value of zero would result in a value of 12/30/1899 according to
this

http://support.microsoft.com/kb/130514/en-us

So something is going haywire. Could you add a field into the
underlying query for the report that formatted the date into a text
value using a format function like

MyDateField:Format([YourDateField],"mm/dd/yyyy")

and then put that into the group footer in a TEXT BOX?

At this point it would seem you are getting NOTHING in that date field
if you are getting that invalid date result.

Good luck!  Keep trying! Easy for ME to say. I'm about to leave for home. ;-)

GK



On Fri, Sep 17, 2010 at 12:53 PM, Debbie <delam at zyterra.com> wrote:
> 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
>



-- 
Gary Kjos
garykjos at gmail.com