<div>
dlookup can only be as effecient as the indexes that exist on the table that is &quot;looked up&quot;.<br />
please give information about the dlookup call, and the indexes in the table.
</div>


<div>
The Left Join was the trick. &nbsp;I changed the query and VOILA!<br />
<br />
Thanks!
</div>


<div>
<div class="content wysiwyg-content">
I have a continuous for with several DLookup Text Boxes (which are terribly slow). &nbsp;Since these aren't part of the underlying query, is it at all possible to derive a SUM in a footer. &nbsp;I've read &quot;Sum in datasheet subform with dlookup fields&quot;. &nbsp;Tried DSUM to no avail. &nbsp;Can't seem to figure it out.
</div>
</div>


I have a continuous for with several DLookup Text Boxes (which are terribly slow).  Since these aren't part of the underlying query, is it at all possible to derive a SUM in a footer.  I've read "Sum in datasheet subform with dlookup fields".  Tried DSUM to no avail.  Can't seem to figure it out.

DLookup SUM

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.