Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
altering details
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
altering details
Hi Doug,
I entered what you suggested but I got a syntax error. This what I have entered {=(1000000 + {MERGEFIELD "Control_Num"})\# "00000000"} the control number is actually 8 digits and not 17 as I earlier stated so i have added an extra 0 to the =function. "Doug Robbins - Word MVP" wrote: 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
altering details
sorry the number is 8 digits and not 7 as i earlier stated
"Boots" wrote: Hi Doug, I entered what you suggested but I got a syntax error. This what I have entered {=(1000000 + {MERGEFIELD "Control_Num"})\# "00000000"} the control number is actually 8 digits and not 17 as I earlier stated so i have added an extra 0 to the =function. "Doug Robbins - Word MVP" wrote: 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
altering details
Did you use CTRL+F9 for the field boundaries?
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Boots wrote: sorry the number is 8 digits and not 7 as i earlier stated "Boots" wrote: Hi Doug, I entered what you suggested but I got a syntax error. This what I have entered {=(1000000 + {MERGEFIELD "Control_Num"})\# "00000000"} the control number is actually 8 digits and not 17 as I earlier stated so i have added an extra 0 to the =function. "Doug Robbins - Word MVP" wrote: 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 |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
altering details
i didn't. thanks for that. it works now. just out of interest why does
putting the field boundaries in with ctrl +f9 work but doesn't when you put them in manually? "Graham Mayor" wrote: Did you use CTRL+F9 for the field boundaries? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Boots wrote: sorry the number is 8 digits and not 7 as i earlier stated "Boots" wrote: Hi Doug, I entered what you suggested but I got a syntax error. This what I have entered {=(1000000 + {MERGEFIELD "Control_Num"})\# "00000000"} the control number is actually 8 digits and not 17 as I earlier stated so i have added an extra 0 to the =function. "Doug Robbins - Word MVP" wrote: 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 |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
altering details
If you type them in manually they are not fields but curly bracketed text.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Boots wrote: i didn't. thanks for that. it works now. just out of interest why does putting the field boundaries in with ctrl +f9 work but doesn't when you put them in manually? "Graham Mayor" wrote: Did you use CTRL+F9 for the field boundaries? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Boots wrote: sorry the number is 8 digits and not 7 as i earlier stated "Boots" wrote: Hi Doug, I entered what you suggested but I got a syntax error. This what I have entered {=(1000000 + {MERGEFIELD "Control_Num"})\# "00000000"} the control number is actually 8 digits and not 17 as I earlier stated so i have added an extra 0 to the =function. "Doug Robbins - Word MVP" wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save a Word Doc to enter details without page changing | Microsoft Word Help | |||
Change default details that show in Open list of files | Microsoft Word Help | |||
How to change details in specific records on a mail merged Letter | Microsoft Word Help | |||
Word 2002-Inserting .jpg's as details vs thumbnails | Microsoft Word Help |