View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
RobFJ RobFJ is offline
external usenet poster
 
Posts: 2
Default Format change from Access to Word

I'm using Word and Access 2007.

The mailmerge fields come from an Access query and one of the fields in the
query is formatted as currency with zero decimal places.

That particular field has one of ten values in it. If I run the query in
Access, all ten show the correct format.

However, when I run the mailmerge in word, nine of those values are as I'd
expect (eg £12345); the tenth has three decimal places (eg £12345,678).

I'm lost as to what to do.

Can SKS help

TIA


Rob