Mail Merge between Access and Word (Office 2002)

  • Thread starter Thread starter Kevin Anthony Jones
  • Start date Start date
K

Kevin Anthony Jones

I'm currently working with MS Access 2002 and MS Word
2002. I am attempting to create a mail merge based on a
query I designed in Access. All of the fields populate
the way that they should, except for the fields that I
have created formulas in.

For example, I created a formula to determine the total
maximum hours for an employee based on his start and end
date. When I enter the formula in Access, I have no
problem viewing it's attributes (General Number, 0
decimals points after). The problem occurs when I use the
mail merge feature in Word to populate this information.
When it populates in my desired field, the number appears,
but without the attributes that I have set. Instead of a
general number with no decimals, I receive the entire
formula result (I.e. 1234.56789). This is a similar
instance when I attempt to define the maximum amount of
payment for each employee based off of my other fields.
Is there a more efficient way to produce this information
as part of my mail merge, or is there something that I'm
doing wrong. Thanks in advance for your advice.

KAJ
 
Maybe write the data to a specific table, then base the merge on that table
instead of the query.
 
You can set a switch \#0.00 to set the number of decimal places you want
within Word.

Herbert
 
Back
Top