 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2007Use DSum ?
I wanted to know if DSum could be used for the following: =Sum ([text174], [BenefitType],[ETR Only]) Which I understand to mean... Sum everything in Text174, where Benefit Type is ETR Only. Yes?? Text 174 is in the details section, and Benefit Type is not a Header or Footer, but it is a field in the details section. This doesn't work. Thanks! Probably you want something like the following. Replace SomeFieldInRecordSource with the Control source for text174 - probably a field name in your table or query for the report. =Sum (IIf([BenefitType] ="ETR Only", [SomeFieldInRecordSource], Null))  SignatureJohn Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . >I wanted to know if DSum could be used for the following: > [quoted text clipped - 9 lines] > > Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.