Solved

Access Report Using DSUM equation

Posted on 2006-06-13
3
248 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

689 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