Access Report Using DSUM equation

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??
m7johnsonAsked:
Who is Participating?
 
rockiroadsConnect With a Mentor Commented:
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
 
m7johnsonAuthor Commented:
wow...that was easy....thanks
0
 
rockiroadsCommented:
No probs
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.