title: Implementing a "special" Access database to Expression Web
body: <p>I have just got an <a href="https://stackoverflow.com/questions/3032719/sql-combining-the-result">answer</a> to my question about combining the result of a SQL. This was done with "ConcatRelated". Now I want to implement this in Expression Web 3.</p>
  
  <p>The SQL's I used in Access:</p>
  
  <pre><code>SELECT land.id, land.official_name, vaksiner.vaksiner
  FROM land INNER JOIN (vaksiner INNER JOIN land_sykdom ON vaksiner.id = land_sykdom.sykdom) ON land.kort = land_sykdom.land
  ORDER BY land.official_name;
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT DISTINCT id, official_name, ConcatRelated("vaksiner","qryVaksinerRaw","id = " &amp;    [id]) AS vaksiner
  FROM qryVaksinerRaw;
  </code></pre>
  
  <p>The last is saved as vaksine_query</p>
  
  <p>This is the SQL that I want to add to Expression Web:</p>
  
  <pre><code>SELECT vaksine_query.id, vaksine_query.official_name, vaksine_query.vaksiner
  FROM vaksine_query
  WHERE vaksine_query.id="?";
  </code></pre>
  
  <p>Expression Web gives me the error message "Undefined function 'ContactRelated' in expression.</p>