can you merge from an access report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in our Access contacts database (which I did not create) and
have now been told to merge this into a word document. I have only merged
into word docs with queries, and when I try to merge from the access database
I can only choose from the queries and not reports.
 
Reports have Record Sources that are tables, queries, or SQL statements. You
should be able to change any SQL statement to a saved query for merging with
Word.
 
leabee1 said:
I have a report in our Access contacts database (which I did not create) and
have now been told to merge this into a word document. I have only merged
into word docs with queries, and when I try to merge from the access database
I can only choose from the queries and not reports.
Click to expand...


That is correct, you should merge from a query.

Generally, you'll want to use the report's Record Source
query (look at the property in the report's design), but you
may have some other things going on there so it may not be
quite that easy.
 
Back
Top