Hyperlink field display

[Guest]

Hi. I have a table that has two fields: 1) "School name" (text field) and
"School Web Site" (hyperlink field). I would like to create a query that
would display the value in the "School Name" field but link to the URL
defined in the "School Web Site" field. I am using Access 2007.

Thanks.

 

[Guest]

I have the exact same need - have you figured out how to accomplish this. I'm
not having any luck.

Thanks