Access Report Using DSUM equation
Posted on 2006-06-13
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).