Thanks in advance for everyone's help.
I create two reports in access
report 1 with detailed information (company name, info, status, details etc)
report 2 is an outline form of report 1 with company name, status, and a link that I want to directly into the report 1
I publish both forms into word.
My problem is I do not know how to dynamically general a hyperlink that will link directly to the company
report 2 when created looks something like this:
Company Name Status Hyperlink
Gap Closed report1.rtf#Company Name
Limited Open report1.rtf#Company Name
I need it to look like this:
Company Name Status Hyperlink
Gap Closed report1.rtf#Gap
Limited Open report1.rtf#Limited
I do not want to manually change each link; however, I can not figure out how to format the hyperlink so that the company name is a field variable and not static text.
Sam
I create two reports in access
report 1 with detailed information (company name, info, status, details etc)
report 2 is an outline form of report 1 with company name, status, and a link that I want to directly into the report 1
I publish both forms into word.
My problem is I do not know how to dynamically general a hyperlink that will link directly to the company
report 2 when created looks something like this:
Company Name Status Hyperlink
Gap Closed report1.rtf#Company Name
Limited Open report1.rtf#Company Name
I need it to look like this:
Company Name Status Hyperlink
Gap Closed report1.rtf#Gap
Limited Open report1.rtf#Limited
I do not want to manually change each link; however, I can not figure out how to format the hyperlink so that the company name is a field variable and not static text.
Sam
