DSUM Function

[SHIPP]

=DSum("[0]","qxtbDivisionDecCodeCurrentPreviousWeek",
"[SortOrder] = 'Current'" & " and [NASCResponsible]=" & [Me].[NASCResponsible])

Can anyone tell my why this DSum function returns #Error.

 

[Ken Snell]

"[0]" is not appropriate for the field name. One, a field cannot be named as
a number; two, you don't use [ ] when naming a field in this argument.

Are you trying to count the number of records that match the criteria? Or
are you trying to add a number together each time a record matches?

Please provide more info about what you're trying to accomplish.