title: Access-Adding a Calculated Field from a Linked Excel Table
body: <p>I have two tables, Table: A which is built in Access and Table: Error which is a linked table in Excel. The Error Table has the calculation that is SQL coding that I want to be in the Query within Access. An example of the Error is: </p>
  
  <pre><code> IIf([Table A].[RETURN_DAYS]&lt;&gt;30,"-RETURN POLICY DAYS SHOULD BE 30","")
  </code></pre>
  
  <p>The Columns in the Errors Table are:</p>
  
  <pre><code>|Audit Name|Error Codes|
  |Audit 1   |the code above
  |Audit 2   | 
  </code></pre>
  
  <p>Currently I manually Copy and paste the Error Code into the Query within the Field from the Excel table in order for the calculation to take place. This takes an incredibly long time since I have over 150+ Audits and 5 Different Error fields.</p>
  
  <p>I want to be able to  select the error from the error column in the linked table that is applicable based on the Audit name and place that error in the field so that when the Query is ran, access completes the calculation. I can not find any information on how to do this or if its possible. Any help is appreciated.</p>