Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Merge access into Word 2007
I have created a table in Word 2007 and merge it with information from a
table in access 07. One of the fields in access is a student gpa. When it merges into the table in word it adds additional numbers. It does not do this to all the records just a few. I can not see a pattern and don't understand the problem. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Merge access into Word 2007
Word is probably displaying the numbers in the way in which they are stored
in Access. You can force them to be displayed in a particular format in two ways: One is to use a select query in Access in which you use the Format() function to control the format of the data. The other is to use a formatting switch added to the merge field in Word. See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- 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 "Julie" wrote in message ... I have created a table in Word 2007 and merge it with information from a table in access 07. One of the fields in access is a student gpa. When it merges into the table in word it adds additional numbers. It does not do this to all the records just a few. I can not see a pattern and don't understand the problem. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Access form/subform fields into Word 2007 document? | Mailmerge | |||
Word and Access 2007 Mail Merge Problem | Mailmerge | |||
Create Mail Merge List/Database in Access 2007 | Mailmerge | |||
Can I mail merge from Access 2007 to Word 2003? | Mailmerge | |||
Using Office 2007 & cannot do a mail merge using Access Query | Mailmerge |