Help - Query merge to a Word doc

  • Thread starter Thread starter ChrisK
  • Start date Start date
C

ChrisK

I am trying to merge records from a query to a Word doc. I set up the
original query and merge doc and they work fine. I then made a copy of the
1st (primary) query and slightly modified it and saved it as a different
query. I didnt change the basic structure of the query, just the search
criteria. When I try to merge the second query into my Word doc, I get no
results even though when I run the query in Access it work fine and I get
results.....I have a major report due today and I desperately need this to
work...

Thanks
 
Query 1 and 2 both look at a single table. The changes I made were in 1 table
field and in 3 calculated fields. When I merge the data into Word I am
recieving messages that the calculated fields dont match any field on the
Word doc and when I look in the insert merge field box they dont show up.
They show up and run fine in Access
 
Your changes affected the field names in query output. Solution is to redo
the Word document fields or create a onther query that uses aliases to output
the same names as the orignal query.
 
Back
Top