RE: [MS_AccessPros] Another DSum Question

I try to avoid using DSum() in reports. Minimally, you need to have an "=" in front of the expression.

Make sure the control is in the Report Footer and not the Page Footer.
Consider changing the control source to:

=Sum(Abs([Empl Cls Cd]='CLS') * [TEMPE])

This should be much more efficient and accurate since it aggregates over the report's records, not the query's records.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: luvmymelody@yahoo.com
Date: Wed, 3 Aug 2011 19:15:22 +0000
Subject: [MS_AccessPros] Another DSum Question

Hello all,

I have another DSum question. I have a report that the source is a crosstab query named qryCrosstabForCarrie.
There are at least 3 Class codes which include CLS, ADM or SRP. I am trying to have a summary at the bottom of the report that will sum each of these class codes. Currently I have a DSum on the report that looks like this

DSum("[TEMPE]","qryCrosstabForCarrie","[Empl Cls Cd]='CLS'")

But I get #Error on the control.

Any help would be of great assistance to me.

Thank you

Jim Wagner

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/