View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default altering details

Try adding 100000 to the mergefield using the following calculation field
construction

{ = (100000 + { MERGEFIELD [Access Field] }) \# "0000000" }

--
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

"Boots" wrote in message
...
I am merging from an Access database query. One of my fields is a 7 digit
number that always begins with '05'. Is it possible to change this within
word so that it is prefixed with '06' instead, with out changing it in
Access? so instead of saying 0512345 it would say 0612345

thanks