[William5271]

I am working on a mail merge from an Access query, and I am trying to
reformat one of the date feilds that is in the numerical format. I want the
date to be written out (January 17th, 1997) rather than the numerical
(1/17/1997). The original feild in the query is in the numerical. How do I
get word to re-format the feild to a written out format?

Thanks in advance

[Cindy M.]

Hi ?B?V2lsbGlhbTUyNzE=?=,

I am working on a mail merge from an Access query, and I am trying to
reformat one of the date feilds that is in the numerical format. I want the
date to be written out (January 17th, 1997) rather than the numerical
(1/17/1997). The original feild in the query is in the numerical. How do I
get word to re-format the feild to a written out format?

Well, the Word-centric way is to add a formatting switch to the field code.
For example:

{ Mergefield MyDateField \@ "MMMM d, yyyy" }

(Note that you can't get the "th" with a single field switch. You'd have to
break it down into multiple fields, one for each part of the date. Then you
should be able to use the \* Ordinal switch for the day of the month.)

The Access-centric approach, which is something to consider if you need this
information more than once, is to create a query. Specify the number format as
part of the query.

In an empty column of the query design grid, something like this:

MergeDate: Format(MyDateField, "MMMM d, yyyy")

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

[Denise M]

Will this also work if your data is coming from an excel file?
Thanks,
Denise

"Cindy M." wrote:

Hi ?B?V2lsbGlhbTUyNzE=?=,

I am working on a mail merge from an Access query, and I am trying to
reformat one of the date feilds that is in the numerical format. I want the
date to be written out (January 17th, 1997) rather than the numerical
(1/17/1997). The original feild in the query is in the numerical. How do I
get word to re-format the feild to a written out format?

Well, the Word-centric way is to add a formatting switch to the field code.
For example:

{ Mergefield MyDateField \@ "MMMM d, yyyy" }

(Note that you can't get the "th" with a single field switch. You'd have to
break it down into multiple fields, one for each part of the date. Then you
should be able to use the \* Ordinal switch for the day of the month.)

The Access-centric approach, which is something to consider if you need this
information more than once, is to create a query. Specify the number format as
part of the query.

In an empty column of the query design grid, something like this:

MergeDate: Format(MyDateField, "MMMM d, yyyy")

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

[Graham Mayor]

The field switch will work - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Denise M wrote:
Will this also work if your data is coming from an excel file?
Thanks,
Denise

"Cindy M." wrote:

Hi ?B?V2lsbGlhbTUyNzE=?=,

I am working on a mail merge from an Access query, and I am trying
to reformat one of the date feilds that is in the numerical format.
I want the date to be written out (January 17th, 1997) rather than
the numerical (1/17/1997). The original feild in the query is in
the numerical. How do I get word to re-format the feild to a
written out format?

Well, the Word-centric way is to add a formatting switch to the
field code. For example:

{ Mergefield MyDateField \@ "MMMM d, yyyy" }

(Note that you can't get the "th" with a single field switch. You'd
have to break it down into multiple fields, one for each part of the
date. Then you should be able to use the \* Ordinal switch for the
day of the month.)

The Access-centric approach, which is something to consider if you
need this information more than once, is to create a query. Specify
the number format as part of the query.

In an empty column of the query design grid, something like this:

MergeDate: Format(MyDateField, "MMMM d, yyyy")

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)