Help Please yet again

[Guest]

I am trying to replace the first two charactars in a date field with the
value 01 instead of the record date. I am exporting the data to Excel for
pivot table reports
and it's easier to sort & group records by a full date value as opposed to
the month/year format

Thanks in advance for any help

 

[Duane Hookom]

If this is a date field, there is no need to replace any "characters". The
complete date is stored with a year, month, day, and possibly time.

 

[Jack MacDonald]

IIRC, you can control the date format that Access sends to an Excel
file by using the Format() function on the date field in the query
that you export to Excel.

I am trying to replace the first two charactars in a date field with the
value 01 instead of the record date. I am exporting the data to Excel for
pivot table reports
and it's easier to sort & group records by a full date value as opposed to
the month/year format

Thanks in advance for any help

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security