Date problem in Mail Merge

N

Noel

Hi. Strange problem with long date format not transferring
to a MailMerge document. I have used the Date:() function
in a query and set Format to long date (ie 03 September
2003). This works when I run the query but when I open a
Merge doc on this query and select the Date Merge field it
comes out in short format (ie 03/09/03). I have set the
format in word to long date and thats what appears when I
insert date using Word, so why is the format changing from
the Query to Word? Thanks, Noel
 
C

Craig Huggart

Noel:

Try right-clicking on the mail merge code in Word and see if you can't edit
the code to get what you what.

Craig Huggart
Microsoft XP Master Instructor
(e-mail address removed)
 
V

Van T. Dinh

The Format setting doesn't get transferred to Word.

Use the Format() function instead. In your Query, create a Calculated
Column:

FDate: Format(Date(), "dd MMMM yyyy")

and use this Column in Word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated text to date query - urgently need help please 4
Microsoft Access Converting Dates 2
Extract date from date/time field in query used with mailmerge. 3
insert date format changing 1
Using Dates in a query 4
Mail Merge Problem 3
Crosstab Query by Week with Dates as Headers 5
Format() function in Access 2003 4

Top