Merged data, access to word, adds the time in date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am merging data from word to access. In the date field, it add the time.
I have corrected this in both word and access, where it shows Insert date &
time. But it still adds the time when I merge into my word letter.
 
Dates always include a time in VBA.

You can create a query that replaces the date field with the Format function
used on that field to convert the date into a string that only contains the
date, and then use that query rather than the table for your merge.
 
You must log in or register to reply here.

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

How to subtract a number from a Mergefield? 0
Mail Merge using ACCESS 3
UK dates in database appearing as US dates in a mail merge document 2
Trouble with some mail merges between MS Access & Word 2
SP3 and Mail Merge 1
Access to Microsoft Word Merge (simple math) 5
date format reversed when merged into word 1
Mailmerge from Access to Word 16

Back
Top