View Single Post
  #1   Report Post  
Kenny G
 
Posts: n/a
Default Math In Merge Field(s)

Hi,

I have a question using math in merge fields. First time user in this area.

We use Access 2002 and Word 2002

Beside the regular merged data I have a field inside the Word document that
is not exactly a merged field. This field would be the results of a series
of questions in the Access query that the Word document derives its data from.

There are a series of questions (total of 16) that provide the answer for
this field.
The number of yes responses need to be counted and divided by the 16 fields
and a percentage be assigned to this field based on the number of yes
responses.

ie 12(yes)/16(totalfields) = 75%

Based on what I have seen on Graham Mayor's web site I gather something like
the following needs to be done:

{=({XXXXXXXXXX}*100\#"0%"}

Hope its not as clear as mud. I need to try to fill in the XXXXX portion of
the above.
How do I go about entering the math to get my answer?

Thanks for your assistance.

Kenny G



--
Kenny G