Help Please yet again

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


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