DSUM Problem - Summing just the records for the specified row

  • Thread starter Thread starter RockNRoll
  • Start date Start date
R

RockNRoll

Thank you Graham and Marshall for your help in my previous post with the
DSUM question.

I have a problem, though. It is in the details section of the report and it
is summing all of the records in the report, not just the ones with the job
specified via the row of the detail. How can I make sure my formula will
just sum the field [Award Amount] for the specified month for the program
specific to the row of the report?

Here is the formula I have right now:

=DSum("[Award Amount]","tbl_Awards","month([Award Date])=1")

Again, the problem is that it is summing ALL the records.

Thanks for your help,
-Dave
 
How can I make sure my formula will
just sum the field [Award Amount] for the specified month for the program
specific to the row of the report?

Here is the formula I have right now:

=DSum("[Award Amount]","tbl_Awards","month([Award Date])=1")
Click to expand...

Include an additional criterion to limit the program:

=DSum("[Award Amount]","tbl_Awards","month([Award Date])=1 AND
[programID] = " & [ProgramID])

where ProgramID is my hazy guess at the field that identifies the row.
 
Back
Top