Hi
I have been trying to do the following using Office XP under Windows
XP, but have not been able to work out how to despite much research.
Hope someone can give me some tips.
I have an Access database with, among other fields, the date and
various money amounts fields.
When I use Word during mail merge, the date format is not the same as
what I have defined in the database. The database field correctly
shows the format d MMMM yyyy, but the Word field displays d/M/yyyy.
FIRST QUESTION: What do I have to do to get the format I want in the
Word document?
The various money amounts are sometimes zero. When that happens, I
want the fields in Word to show blanks, but it now displays the
number 0. Also, when the money amount has four digits, I want a
comma separator, which is not there at present. (Note: The Access
fields have blanks for zeroes, and comma separators for four digits
or more.)
SECOND QUESTION: How do I get blanks for zero fields and separators
for four or more digit numbers in the Word document?
Thanks for any tips.
----------------------------
Chew Yoke Lim
Kuala Lumpur, Malaysia
e-mail: [log in to unmask]
----------------------------
PCSOFT maintains many useful files for download
visit our download web page at:
http://freepctech.com/downloads.shtml
|