[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___