Dsum in a calculated field

[JonathanT]

I am having difficulty in obtaining the correct result when using a calculated field in a report.
Domain is a table is called "data"
Expression is a field is called [other]. This is a YES/NO field whose underlying values are -1 and 0
Criteria are fields called [curryear] and [quarter]

I can get the correct results with one criteria, however when I try to combine two criteria the result is incorrect

=DSum("[other]","data","[curryear]=2010") gives the correct result of -26

=DSum("[other]","data","[quarter]=1") gives the correct result of -7

=DSum("[other]","data","[curryear]=2010" And "[quarter]='1'") should

return -7 instead it returns -27 which is a combination of all years in the "data" table.



Any help would be appreciated

[RuralGuy]

Try:
=DSum("[other]","[data]","[curryear]=2010 And [quarter]=1")
...and DATA if a future Reserved word and should not be used as is.
http://www.allenbrowne.com/AppIssueBadWord.html#D

[JonathanT]

Thank you very much. It worked perfectly

[RuralGuy]

Glad we could help.