<div>
wow...that was easy....thanks
</div>


<div>
<div class="content wysiwyg-content">
Here is my current equation<br />
<br />
=DSum(&quot;[Assets]&quot;,&quot;Case Log Current Year&quot;,&quot;[Status Change Date] &gt;= #1/1/2006# &nbsp;AND [Status Change Date] &lt;&nbsp;#4/1/2006# AND [myStatus] = 'Client' AND [OWNER] = 'Lead, CC'&quot;)<br />
<br />
However I can not figure out how to have the equation sum the assets for a record where myStatus = Client and OWNER = either Lead, CC or Lead, AA or Lead, BB......I can only get it to sum as show above (with only one owner).<br />
<br />
Ideas??
</div>
</div>


Here is my current equation

=DSum("[Assets]","Case Log Current Year","[Status Change Date] >= #1/1/2006#  AND [Status Change Date] < #4/1/2006# AND [myStatus] = 'Client' AND [OWNER] = 'Lead, CC'")

However I can not figure out how to have the equation sum the assets for a record where myStatus = Client and OWNER = either Lead, CC or Lead, AA or Lead, BB......I can only get it to sum as show above (with only one owner).

Ideas??

Access Report Using DSUM equation

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.