Data Source: Independent database. Also database is running the merge into
saved Word template. database field set to be a number with particular
formatting. Internal calcs in database are based on this field as number.
Yes Ctrl-F9 was used to insert both sets of {}
When said database runs the merge final doc says {=$875.00*12 \# $,0.00"}
Toggled :!Syntax Error, "
Rent_Mnth returns correct value. No calc performed. Also, looks like
merged doc still has fields.
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > Using a Word data source, with data such as $875.00 and a calculation field
> {= {MERGEFIELD Rent_Mnth} * 12 \# "$,0.00"} the calculation is performed OK
> here. What is your data source? Did you use Ctrl+F9 to insert the field
> delimiters { }?
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "Gladriella" <Gladriella[ at ]discussions.microsoft.com> wrote in message
> news:45203BF8-FB17-4F39-9F84-0CFDF0161A1E[ at ]microsoft.com...
> >I am trying to do a calculation with merge field data. However, my data is
> >a
> > formatted number with a $ at the beginning. Changing the original data to
> > a
> > number only is not an option. I am working with Word 2003.
> >
> > By reading earlier posts I have figured how to do the actual calc I just
> > don't know how to get it to ignore the preceding $.
> >
> > Data: $875.00
> >
> > Would like to take monthly amount and calc annual amount
> > {= {MERGEFIELD Rent_Mnth} * 12 \# "$,0.00"}
> >
> > Cannot calc due to $. :(
> >
> > Thank you in advance for your assistance.
> >
> >
>
>
>
|