I am trying to run a mail merge using currency results from Access make table query going through Word to send emails. When running the merge the table result shows the correct currency figure, but when this appears in word it shows up as 13 x Kayaks @ 27 5 each = 357 5
Instead of displaying @ £27.50 = £357.50
So add the following code in mergefield to convert it to currency in alt F9 \# £,0.00
but the results then come up as 13 x Kayaks @ £32.00 each = £362.00
So it appears to be adding the two figues displayed of 27 & 5 and 357 & 5 instead of taking account of the decimal point!!
The figures are correctly being displayed in the table, so how on earth do I get the correct figures to show in word??
:banghead::banghead:
Instead of displaying @ £27.50 = £357.50
So add the following code in mergefield to convert it to currency in alt F9 \# £,0.00
but the results then come up as 13 x Kayaks @ £32.00 each = £362.00
So it appears to be adding the two figues displayed of 27 & 5 and 357 & 5 instead of taking account of the decimal point!!
The figures are correctly being displayed in the table, so how on earth do I get the correct figures to show in word??
:banghead::banghead:
Last edited: