Help Please yet again

S

Stephen

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
 
D

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.
 
J

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
Click to expand...


**********************
[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Top