Link Access Report In Word

[rcorbett]

I have an Access Report which contains information about volunteers that is based on a Query. I also have a Word file that contains a calendar. What I want to do is this: I want to link and/or import the access report into the Word file so that I can easily update the word file when the report data changes. I know I can publish the report in word but all that does is over-write the existing file or creates a new one. Does anyone have a solution to what I am missing?

Thanks

 

[JoanneM]

Morning
it's 7:04 and I'm just off to the gym when I get back in an hour or so I'll check this out.
But first is the calendar an add in of some sort or is it a table in word & do you want to update this calendar or just the document or are you planning a week to view diary effect?

Talk to you at 8:30- 9:00 am

regards

Jo

 

[rcorbett]

The calendar is not linked to Access at all - it is seperate and is manipulated on a monthly basis. Basically, I want to take an access report and insert it as Page 2 with the calendar (created in Word)as Page 1. This report will change on a monthly basis so I was hoping that by opening the Word document(inlcludes calendar)it would prompt for an update to the Access Report. This is similar to linking workbooks in Excel.