Formatting a date in a querie for a merge with Word

  • Thread starter Thread starter Vickie Ward
  • Start date Start date
V

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
 
In the field row of your query, enter an expression like this:
Format([MyDate], "mmm d yyyy")
 
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
Click to expand...


.
Click to expand...
 
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.

Vickie Ward said:
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
Click to expand...


.
Click to expand...
Click to expand...
 
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
Click to expand...
like
this:
Format([MyDate], "mmm d yyyy")
"Vickie Ward" <[email protected]>
Click to expand...
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
Click to expand...
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


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top