Mail Merging

[mali]

Hi everybody,

I am having major problems with dates when merging from my MS Access in word, I am currently using Office XP Pro.

The problem that im having with dates is that, if there is a date within my database for when someone who started work on a particular date, for e.g. 12/05/2003, when i create a letter in word and merge that date field within word, it comes up as 5 december 2003 and not 12 may 2003, its reversing the date, ive made sure everything is in UK format, please can someone help me, i also have a problem with blank fields, when i merge the date field and if its blank it defaults to 12:00AM, this is bizarre

any help would be much appreciated

 

[Pat Hartman]

Make sure that your windows default is set to the correct date format. If you still have a problem, you can use a query to format the date and then merge to that.

Select Format(YourDate, "dd/mm/yyyy") As SomeDate, ....

The Format() function will turn the date field into a string so Word won't mess with the format.