I have an Access database collecting information and then using as a query to merge into a Word Letter. The Merge works fine but dates convert from long date (January 1, 2014) to a short date (1/1/2014) and it is nerve wracking and just . In my database format is set to mm dd, yyyy. Also, for the letter have a dollar figure. I figured out to round the number but when merged it converts from 80,500 to 80500. Even if I set the format to currency, it converts to a number with no comma. Don't mind the .00 after the number not being there. Any thoughts, are appreciated.
Sonya