Access and Word Mail Merge

[Guest]

I've created a formula in an Access query to determine the MAXIMUM HOURS an
employee can work based on their start and end date. From there I create I
can create a MAX PAY formula that calculate the maximum hours mulitipled by
the hourly rate of the employee. This appeared to be an easy practice.

Please note that under each fields property, I set the appropriate FORMAT
and DECIMAL PLACES fields to fit what I'd like to do.

The problem, however, is that when I attempt to mail merge these fields into
my Word document, the doc displays the entire forumula solution instead of
the formatting and decimal places issues that I set in Access.

Is there a reason for this? How can I set the mail merge results to reflect
the field properties that I set in Access? Thanks in advance for your
suggestions.

KAJ

 

[Albert D. Kallal]

Build a nice query.

Get the fields and all the data in the query looking just how you want. If
you have to fix the decimal stuff, then create columns in the query using
the format command.

Now, do export of data on the above query to a text file..and have word
merge on that...

Or, use your query..and grab my super easy word merge here..:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html