IMPORTING to WORD

[Pat]

I just discovered I can set up a merge file and import from my database.
I did a test but discovered that the formatting changes.
For example: 6% is now 5.99999999999999-2-E
dates are either 12/10/07 or 12:10:07:0000

There are others but before I list everything is there a quick way to ensure
that the formatting imports as established when setting up the table?

 

[Roger Carlson]

Instead of merging from the table, merge from a query where you have
formattted your data the way that you want. You can use the Format command
to format fields in your query. For instance, if you use something like
this in your query:

MyDateFormatted: Format([MyDate],"mmm dd"", ""yyyy"),

it will return Apr 29, 2009.

another example:

MyPercent: Format([MyField],"0%")

will format your field as a percent.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L