[Tom]

Hi I am using word 2007. I have a mail merge in which I am using nested if
statements . I want to assign a customer discount for the balance based on
the city of residency. For example, If they live in Akron , I want the bill
reduced by 10%. If they live in Cleveland I want the bill to be reduced by
12% and so on.

I have a field called TotalAccountBalance that is being passed back to word
from an access database calculated query. I tried {if{city}="Akron"
"{TotalAccountBalance}-{Total Account Balance *.10}" and so forth. I believe
this can be done. Can anyone help? Thanks

Tom

[macropod[_2_]]

Hi Tom,

See my reply in microsoft.public.word.vba.general

Please don't post the same question separately in multiple NGs.

--
Cheers
macropod
[Microsoft MVP - Word]


"Tom" wrote in message ...
Hi I am using word 2007. I have a mail merge in which I am using nested if
statements . I want to assign a customer discount for the balance based on
the city of residency. For example, If they live in Akron , I want the bill
reduced by 10%. If they live in Cleveland I want the bill to be reduced by
12% and so on.

I have a field called TotalAccountBalance that is being passed back to word
from an access database calculated query. I tried {if{city}="Akron"
"{TotalAccountBalance}-{Total Account Balance *.10}" and so forth. I believe
this can be done. Can anyone help? Thanks

Tom