Date problem between Access and Word when mailmerging

[Guest]

I have Query in Access which merges into word document, all is well except
Date fields return to USA date format i want them to appear in Australin date
format, can any one help. Also in same query i have currency feild when i
insert them to word documnt it does not bring the dollar signs with it.

I have changed the date format both in control panel and at word language
setting level but still causing problems.

 

[Allen Browne]

Create a query, and use it (not the table) for the mail merge.

In the query, use the Format() function so that Access sends the text
version of the fields to Word, instead of the numeric version. That way Word
can't get it wrong.

Example of what to type in the Field row of your query:
Format([InvoiceDate], "mm/dd/yyyy")
or
Format([Amount], "Currency")

(It is also possible to format the fields in the Word document if you prefer
to do it that way.)

 

[Guest]

Thankyou very much u are the best it worked although i cant have my orignial
field name showing as column header but it works thank you once again.

khan from Perth WA

Create a query, and use it (not the table) for the mail merge.

In the query, use the Format() function so that Access sends the text
version of the fields to Word, instead of the numeric version. That way Word
can't get it wrong.

Example of what to type in the Field row of your query:
Format([InvoiceDate], "mm/dd/yyyy")
or
Format([Amount], "Currency")

(It is also possible to format the fields in the Word document if you prefer
to do it that way.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have Query in Access which merges into word document, all is well except
Date fields return to USA date format i want them to appear in Australin
date
format, can any one help. Also in same query i have currency feild when i
insert them to word documnt it does not bring the dollar signs with it.

I have changed the date format both in control panel and at word language
setting level but still causing problems.