Duane,
That worked. I will remember to not use DSum on reports or avoid them.
Thank you
Jim Wagner
________________________________
________________________________
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Wednesday, August 3, 2011 12:33 PM
Subject: 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
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar