Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lynda[_2_] Lynda[_2_] is offline
external usenet poster
 
Posts: 19
Default Need Help with Word 2007 MailMerge Using Access as data source.

Hello, I am having quite a problem with the way a calculated field in an
Access 2007 query is showing up in a Word 2007 Mail Merge document.

In MS Access query, I calculate the decile value of a student's class rank.
For instance, if there is no class rank, the decile is 0. If the class rank
is 8 out of 100, the decile is 1 and so forth. This all works correctly in
Access.

However, when I merge this query into a Word 2007 document, the deciles all
show up as 0 or 10. Somewhere along the way, Word 2007 fails to read the
calculated field correctly.

How can I get the correct results to show up in a mail merge document?

Thanks for your help on this.

Lynda



 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
missing queries in data source list (Word/Access 2007) rwmj Mailmerge 2 March 29th 07 12:35 PM
Mailmerge - Using Word as the data source? mrfrenchy Mailmerge 2 December 7th 06 12:22 AM
How to link a different Mailmerge header source and data source? Eleni_Malli Mailmerge 1 May 3rd 06 02:08 PM
Using Access Data Source for Word Documents Sharon Mailmerge 0 August 24th 05 10:56 AM
Mailmerge data source in an Access database will not open Colin C Mailmerge 3 December 31st 04 12:01 AM


All times are GMT +1. The time now is 12:47 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"