title: Hyperlink in MS Access report
body: <p>I've made an MS Access 2013 database to keep track of all communications regarding a trading website. The tables and columns relevant to this question are Advertisements with columns ID (Number) and Link (Hyperlink), and Notes with column Advertisement, which contains an Advertisement ID. The Link field contains an http link to the advertisement on the website.</p>
  
  <p>It is easy to include the Link column in reports, but to save space, I would like to turn the ID field into a hyperlink with the ID as displayed text and the contents of the Link column as the target. How would I go about that?</p>
  
  <p>I already played a little with the properties of the ID column and set "Is Hyperlink" to true and "Hyperlink target" to "SELECT '#' &amp; Link &amp; '#' AS URL FROM Advertisements", but this didn't work. It may need a WHERE clause, but how would I refer to the value of the ID field of the record in question?</p>