Mail Merge from Access to Word changes the date format in word 1

[vicky1362002]

Hello all,

I am trying to do a mail merge, everything seems to be good.

But, i have a date field in the access query, which is in this format June 19, 1994, this date field when merged to the word changes the format of the date in the word document, i mean to say that when i merge the access query to a word document the date field format i get is 06/19/1994, but the actual format in the access query is June 19, 1994.

Can anyone please help and feel free to ask me any questions if you have.

Thanks,

Vik

 

[PHV]

Did you use the Format function in the query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vicky1362002]

Thanks PHV for you instant reply.

I am getting the correct format which i need in the Query output, but when i am merging it to a word document, the format changes to the standard format mm/dd/yyyy.

The answer your question: NO, i haven't used any format function in the query because am getting the correct output of the date as i need in the query result but not in the merged word document.

Thanks again,

Vik

 

[vicky1362002]

Hey PHV,

Your small tip made it all work, i tried using the Format function in the query and it worked like a charm.

For those who has the same problem, try this:

Even if the query gives out the correct date format which you want, change the query in this way:

Actual Query: select joined_date,name,id from employee;

Change the above query to:

select format(joined_date,"mmm dd,yyyy") AS [joined_date],name,id from employee;

Now using the above changed query if you try merging to the word document, you would get it as it was in the query output.

Thank you again PHV.

PHV, correct me if i went wrong somewhere.


-Vik