<div>
you may break down your function into 2 parts... <br />
<br />
first using your first part of function and see what was being returned?<br />

<pre><code id="code-20-41756030-1">=DLookUp(&quot;Amount_ Aggregate&quot;,&quot;tblDraws&quot;,&quot;ID=&quot; &amp; [DrawIDrpmt])</code></pre>
similarly, do the same for the 2nd function:<br />

<pre><code id="code-20-41756030-2">=DLookUp(&quot;Amount&quot;,&quot;tblDraws_Details1&quot;,&quot;DrawIDrpmt=&quot; &amp; [ DrawIDrpmt]) </code></pre>
this will give you clue which part is getting an error and let you handle that error more efficiently.
</div>


you may break down your function into 2 parts...

first using your first part of function and see what was being returned?


=DLookUp("Amount_ Aggregate","tblDraws","ID=" & [DrawIDrpmt])

similarly, do the same for the 2nd function:


=DLookUp("Amount","tblDraws_Details1","DrawIDrpmt=" & [ DrawIDrpmt]) 

this will give you clue which part is getting an error and let you handle that error more efficiently.

<div>
<blockquote>
 I imagine its a paren 
</blockquote>
Or missing Operator?<br />
<br />
The first argument in DLookup is an expression where vba checks for missing operators.<br />
<br />
DLookup (&quot;x + 2&quot;, ...: Expression to look for value of field x + 2.<br />
<br />
In what Rayan assumed, your code assumes, because of a space in the name, &nbsp;a missing operator between assumed fields: &quot;Amount_&quot; and &quot;Aggregate&quot;.
</div>


> I imagine its a paren

Or missing Operator?

The first argument in DLookup is an expression where vba checks for missing operators.

DLookup ("x + 2", ...: Expression to look for value of field x + 2.

In what Rayan assumed, your code assumes, because of a space in the name,  a missing operator between assumed fields: "Amount_" and "Aggregate".

<div>
That was it. &nbsp;Thank you
</div>


<div>
<div class="content wysiwyg-content">
Hello, I am trying to substract 2 separate values in the following but I get a #error. &nbsp;I imagine its a paren but not sure where. &nbsp;thank you in advance. &nbsp;<br />
<br />
=DLookUp(&quot;Amount_ Aggregate&quot;,&quot;tblDraws&quot;,&quot;ID=<wbr />&quot; &amp;&nbsp;[DrawIDrpmt])-DLookUp(&quot;Amo<wbr />unt&quot;,&quot;tblD<wbr />raws_Detai<wbr />ls1&quot;,&quot;Draw<wbr />IDrpmt=&quot; &amp;&nbsp;[ DrawIDrpmt])
</div>
</div>


Hello, I am trying to substract 2 separate values in the following but I get a #error.  I imagine its a paren but not sure where.  thank you in advance.  

=DLookUp("Amount_ Aggregate","tblDraws","ID=" & [DrawIDrpmt])-DLookUp("Amount","tblDraws_Details1","DrawIDrpmt=" & [ DrawIDrpmt])

Dlookup

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.