Merging data from Database to a word document
- From: ivan <ivan@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 27 May 2008 02:30:03 -0700
I have a database using Access 97 that has date from 1800 till today and
they are formatted in DD-MMM-YYYY so that a date say 13-5-1881 will be shown
as 13-May-1881. This format is shown correctly in Access for any date. I have
now designed a document using word 97 so that I can merge my data from the
database to word. Unfortunately the date is showing incorrectly when there is
a date before 31-12-1900 as it is shown in American format: that is if the
date is 13-5-1881 it is shown as 5/13/1881 instead of 13-May-1881 the way I
would like to have it. My code for the merge data date is MERGFIELD "Date" \@
"DD-MMM-YYYY" which works well when date are after the year 1900 but not
before. I wonder if someone could help me fix this problem as I can't find
the answer on the Internet.
.
- Follow-Ups:
- Re: Merging data from Database to a word document
- From: Bob Buckland ?:-\)
- Re: Merging data from Database to a word document
- Prev by Date: Re: how to make a banner for etsy
- Next by Date: open Microsoft office word so hard and can't open old doc files
- Previous by thread: Re: how to make a banner for etsy
- Next by thread: Re: Merging data from Database to a word document
- Index(es):
Relevant Pages
|
