Merge Data from Access 2002 has data in blank spaces.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mo - 24 Feb 2004 20:06 GMT

I am trying to merge data from Access 2002 into a Word letter. When I tell mailmerge to link a query (the criteria is for fields that are "IS NULL"), the fields come over to Word filled in with "12:00:00 AM". Why is this happening and how can I make it stop. The fields are all formatted for a short date.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Feb 2004 05:41 GMT

Use the format function on the field in the query to force the date into a
date format without the time.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

>I am trying to merge data from Access 2002 into a Word letter. When I tell
>mailmerge to link a query (the criteria is for fields that are "IS NULL"),
>the fields come over to Word filled in with "12:00:00 AM". Why is this
>happening and how can I make it stop. The fields are all formatted for a
>short date.

Reply to this Message

Mo - 25 Feb 2004 17:51 GMT

I used the format function on the field in the query to force the date into a date format without the time. This did not work. Although the field is formatted for a date, it is blank. It is only the blank ones that come over to word with "12:00:00 AM". My merge works on the primise that certain paragraphs are inserted into the letter depending on which fields are blank. With the time in the field, there are no blank fields, consequently, there are no paragraphs inserted into the letter. And for some reason, not only is the time in the blank fields, but if any of the fields already has a number in them, they are not brought over to word

Reply to this Message