Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sue Sue is offline
external usenet poster
 
Posts: 132
Default Mailmerge from Access using date fields

Hi got a simple Access database for client details. One field is date of
birth. When merging it into letters etc, the date of birth comes thro back
to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the
american way around but can be confusing here. I changed the format on the
DB to medium date. (12-Sep-61) but still back to front. Can someone advise
me? PLEASE!! Many thanks..... Sue
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mailmerge from Access using date fields

Format the mergefield with a date formatting switch \@ "d MMM yyyy" -
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



"Sue" wrote in message
...
Hi got a simple Access database for client details. One field is date of
birth. When merging it into letters etc, the date of birth comes thro
back
to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the
american way around but can be confusing here. I changed the format on
the
DB to medium date. (12-Sep-61) but still back to front. Can someone
advise
me? PLEASE!! Many thanks..... Sue



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge from Access using date fields

In addition to the method that Graham has suggested, you can also use the
Format() function in a query in Access to force the date into the required
format.

Format([Datefield], "d mmm yy")

will convert the contents of the date field to text in the format 12 Sep 61.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Sue" wrote in message
...
Hi got a simple Access database for client details. One field is date of
birth. When merging it into letters etc, the date of birth comes thro
back
to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the
american way around but can be confusing here. I changed the format on
the
DB to medium date. (12-Sep-61) but still back to front. Can someone
advise
me? PLEASE!! Many thanks..... Sue


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge from Access - incorrect date/time format dawnjlane Mailmerge 3 August 3rd 08 12:56 PM
Order of data fields in mailmerge from access table Hannah Mailmerge 1 March 9th 08 07:42 AM
Access Query to mailmerge US Date Big Mac Mailmerge 5 January 2nd 08 06:01 PM
How to use access query computed fields in Word mailmerge Rey Mailmerge 5 June 23rd 05 06:26 PM
empty date fields in access Alan Mailmerge 4 January 13th 05 12:57 AM


All times are GMT +1. The time now is 09:12 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"