time field issue in mail merge
Hi,
I am merging data from an Access 2007 query into a Word 2007 doc, including 2 date/time fields. For one I have added a field switch to only display the data in the desired format (\@ "dddd dd MMMM yyyy"), and am trying to do the same with the second field to only display the time in the hh:mm format.
Unfortunately, it seems that whatever switch I try to use, the field still display as 30/12/1899 hh:mm:ss. I have also tried playing around with the field format in Acces, but this does not seem to change anything.
Would be grateful for any advice!
Aude
|