title: Is it possible to create a recursive query in Access?
body: <p>I have a <code>job</code> table</p>
  
  <pre><code>Id
  ParentID
  jobName
  jobStatus
  </code></pre>
  
  <p>The root ParentID is 0.</p>
  
  <p>Is it possible in Access to create a query to find a root for a given <code>job</code>?
  The database is MDB with no linked tables. The Access version is 2003. A <code>job</code> can be several levels grand children deep.</p>