title: MS Access: How to use calculated field in a sub query?
body: <p>I have problem with the following query  </p>
  
  <pre><code>Select A.PName, (B.Hours+C.Hours) as TotalHours,   
  (select top 1 grade from TableD where TableD.HoursRequire &gt;=**TotalHours**)  
  from TableA A  
  left join TableB B on A.Pname=B.Pname  
  left join TableC C on A.Pname=C.Pname
  </code></pre>
  
  <p>My problem is that the calculated field "TotalHours" is not recognized in the sub query, any help would be appreciated.</p>