Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you create a multi-layered merge where certain merge fields a. | Mailmerge | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Merge Fields in Header? | Mailmerge | |||
Merge Fields, Headers, Etc. | Mailmerge | |||
Using MAILMERGE fields within HYPERLINK fields for Merge to Email | Mailmerge |