Solved

Access Report Using DSUM equation

Posted on 2006-06-13
3
224 Views
Last Modified: 2012-08-14
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
Comment
Question by:m7johnson
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 100 total points
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

by:m7johnson
ID: 16895929
wow...that was easy....thanks
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 16897908
No probs
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now