exporting data

[Guest]

I have set up an query from a table, with calcuations in the query. Now I
want to export those fields to a table in word document. when I go to the
word document and try to bring over the information from the query, it does
give the option to pick that query. what am i doing wrong.

thanks
Roger

 

[Pat Hartman\(MVP\)]

I'm not sure exactly what makes a query invisible to Word but one reason is
that the query is an action query and another is that the query uses a user
defined function. VBA functions may or may not cause problems.

Essentially, there is something in the query that Word won't be able to
interpret.

You can automate the mail merge from the Access end and place your data at
bookmarked spots in a template.