Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Access Report Using DSUM equation

Posted on 2006-06-13
Medium Priority
265 Views
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??
0
Question by:m7johnson
• 2

LVL 65

Accepted Solution

ID: 16895867
try this

=DSum("[Assets]","Case Log Current Year","[Status Change Date] >= #1/1/2006#  AND [Status Change Date] < #4/1/2006# AND [myStatus] = 'Client' AND [OWNER] IN ('Lead, CC','Lead','AA Lead','BB Lead')")

or if u just want anything with the word Lead in it

=DSum("[Assets]","Case Log Current Year","[Status Change Date] >= #1/1/2006#  AND [Status Change Date] < #4/1/2006# AND [myStatus] = 'Client' AND [OWNER] LIKE '*Lead*'")
0

Author Comment

ID: 16895929
wow...that was easy....thanks
0

LVL 65

Expert Comment

ID: 16897908
No probs
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
###### Suggested Courses
Course of the Month13 days, 11 hours left to enroll