Creating a query in VBA - Resolved

I have a word document which I would like to have a hyperlink to an Query held within an Access database. I can hyperlink to the database but not the Query.

Can someone suggest how this can be achieved ? I know I can insert the query using Microsoft Query within Word but I don't always want the information displayed in the document only when the users want it.

I would be very gratefull if someone could help me move forward in this as it is becoming a real pain !