DSUM Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Can anyone tell my why this DSum function returns #Error.
 
"[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.
 
Back
Top