Formatting a date in a querie for a merge with Word

[Vickie Ward]

Hi,

I am having a problem with the way dates appear in Word
after a mail merge with Access. I have tried to do a
picture switch in Word with no luck and now I am trying to
run a querie from Access with the date formatted the way I
want it to appear in Word as suggested in one of the KB
articles that I have read. Where do I put the date format
in my querie? I am running Access 2002 and Word 2003.

Thanks

Vickie

 

[Allen Browne]

In the field row of your query, enter an expression like this:
Format([MyDate], "mmm d yyyy")

 

[Vickie Ward]

Thanks for the fast response Allen,

I typed Expr1: Format([Date Onsite],"dd/mm/yyyy")
Access added the "Expr1:" to it .
Obviously, Date Onsite is the name of the field I am
trying to format. In actual fact there are two more fields
that I need to do the same to, but I thought I would try
to get just one working for a start.

I then executed the merge and a message came up saying
that Date Onsite exsisted in the merge document but was
not in the source data. ie not in my query. So I added the
field Date Onsite with no formatting and of course it did
not work.

HELP!!!!

-----Original Message-----
In the field row of your query, enter an expression like this:
Format([MyDate], "mmm d yyyy")

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

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

I am having a problem with the way dates appear in Word
after a mail merge with Access. I have tried to do a
picture switch in Word with no luck and now I am trying to
run a querie from Access with the date formatted the way I
want it to appear in Word as suggested in one of the KB
articles that I have read. Where do I put the date format
in my querie? I am running Access 2002 and Word 2003.

Thanks

Vickie

.

 

[Allen Browne]

The calculated field has the alias, "Expr1". You can call it anything you
want there: just use a name that is not the same as the original field name.

In your Word document, merge Expr1 or whatever you called it.

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

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

Thanks for the fast response Allen,

I typed Expr1: Format([Date Onsite],"dd/mm/yyyy")
Access added the "Expr1:" to it .
Obviously, Date Onsite is the name of the field I am
trying to format. In actual fact there are two more fields
that I need to do the same to, but I thought I would try
to get just one working for a start.

I then executed the merge and a message came up saying
that Date Onsite exsisted in the merge document but was
not in the source data. ie not in my query. So I added the
field Date Onsite with no formatting and of course it did
not work.

HELP!!!!

-----Original Message-----
In the field row of your query, enter an expression like this:
Format([MyDate], "mmm d yyyy")

I am having a problem with the way dates appear in Word
after a mail merge with Access. I have tried to do a
picture switch in Word with no luck and now I am trying to
run a querie from Access with the date formatted the way I
want it to appear in Word as suggested in one of the KB
articles that I have read. Where do I put the date format
in my querie? I am running Access 2002 and Word 2003.

Thanks

Vickie

.

 

[Vickie Ward]

THANK YOU!!! This works like a dream! After two weeks of
wrestling with this the solution was so easy!!

Thanks

Vickie

-----Original Message-----
The calculated field has the alias, "Expr1". You can call it anything you
want there: just use a name that is not the same as the original field name.

In your Word document, merge Expr1 or whatever you called it.

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

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

Thanks for the fast response Allen,

I typed Expr1: Format([Date Onsite],"dd/mm/yyyy")
Access added the "Expr1:" to it .
Obviously, Date Onsite is the name of the field I am
trying to format. In actual fact there are two more fields
that I need to do the same to, but I thought I would try
to get just one working for a start.

I then executed the merge and a message came up saying
that Date Onsite exsisted in the merge document but was
not in the source data. ie not in my query. So I added the
field Date Onsite with no formatting and of course it did
not work.

HELP!!!!

-----Original Message-----
In the field row of your query, enter an expression

like
this:

Format([MyDate], "mmm d yyyy")
"Vickie Ward" <[email protected]>

wrote
in message

I am having a problem with the way dates appear in Word
after a mail merge with Access. I have tried to do a
picture switch in Word with no luck and now I am

trying
to

run a querie from Access with the date formatted the way I
want it to appear in Word as suggested in one of the KB
articles that I have read. Where do I put the date format
in my querie? I am running Access 2002 and Word 2003.

Thanks

Vickie


.

.