Help - Query merge to a Word doc

[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

 

[ChrisK]

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

 

[KARL DEWEY]

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.

 

[ChrisK]

Thanks Karl as soon as you asked the 2 questions I thought thats what it
might be.