data in mail merge is not the way I have it in Access

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

Guest

I entered dates in my access data base as mm/dd/yy. The last time I used my
mail merge with this data it entered the date with the time included
(mm/dd/yy 12:00am. I do not want the time included but have not been able to
find a way to get rid of it. The time is not included in my access data base.
 
Then you will have to format the data in your merge program. Access stores
dates as a date and time. How the other program formats that data is up to
the other program, not something Acess can control.

If you are in Word, I think you can right-click the data field and format it
to display in a multitude of ways.

Rick B



Cossack said:
I entered dates in my access data base as mm/dd/yy. The last time I used my
mail merge with this data it entered the date with the time included
(mm/dd/yy 12:00am. I do not want the time included but have not been able to
find a way to get rid of it. The time is not included in my access data
Click to expand...
base.
 
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 do i stop dates changing format when mail merging to word? 2
Dlookup 7
date format frustration 3
Change MM/DD/YYYY to MM/DD/YY 5
Matching on Dates & times 21
UK date format in Mail Merge letters 4
Modifying date information 1
30/12/99 date problem 6

Back
Top