MS Word, Access, and merged DATE format?

Question

I am creating Word documents that are being MAIL MERGED using Access query tables. The problem I've run into is--I need to change the date format in the merged Word document. I want to be able to change it in different ways in the Word documents.
The final format I want the date is "Thursday, January 4"
I have tried to edit the MERGEFIELD like this:
{MERGEFIELD "sort_date"\@DDDD-MMMM-DD \*Mergeformat}
which gives me "Thursday-January-4". When I try to change the hyphen to a comma or a space, I get errors. I've tried using ', ' and ", " but nothing works. Is there anyway to insert a space or other text into the MERGEFIELD switch? I am desperate for an answer! Thanks.

Answer 1

the syntax is \@ "dddd, MMMM dd"



in your case it's

{MERGEFIELD sort_date \@ "dddd, MMMM dd" \*Mergeformat}

Answer 2

A database can run on virtually any computer. Oracle has a lightweight client called Oracle Express Edition that is good to start with. MySQL is another common database. Once you have one of these databases installed the options open up. OracleXE has its own design tools. I mainly use the command prompt for the MySQL instance. SQuirreL is a good piece of software to managed databases. I am obviously about open source and free software. But if you are looking for a larger system. Buying dedicated servers for your database and running a heavy weight Oracle system is always an option.

Answer 3

I hope the following links will help you to get the answer.

http://homepage.swissonline.ch/cindymeister/MergFram.htm

http://support.microsoft.com/kb/89532

http://www.gmayor.com/formatting_word_fields.htm

Answer 4

Answer is here

http://www.gmayor.com/formatting_word_fi...