DSUM report

[mveijndh]

I'm trying to generate a total sum in Invoice report. It does not seem to collect the right data. Can I use multiple Criteria in a Dsum?

TotalExpenses: DSum("[tblExpenses]![ExpDeclarationValue]";"queInvoiceExpenses";"Month( [tblExpenses]![ExpDate] =1) And [tblExpenses]![EmployeeID] =1")

Thanks in advance

 

[cyanidem]

You have incorrect number of opening and closing brackets, and some in wrong place as well. try:

TotalExpenses: DSum("[tblExpenses]![ExpDeclarationValue]";"queInvoiceExpenses";"Month([tblExpenses]![ExpDate])=1 And [tblExpenses]![EmployeeID]=1")

 

[JHB]

The field you want to sum and the criteria field, must be in the same table/query, you can't point to another table as you do.
Below is a link to some samples:
http://www.techonthenet.com/access/functions/domain/dsum.php

 

[mveijndh]

Hi,

This does provide better results, but it does not line up with the checked results. Is there a way to check what records the DSUM has used?

 

[mveijndh]

Hi,

I've changed the DSUM to:

TotalExpenses: DSum("[queExpensesOpen]![ExpDeclarationValue]";"queExpensesOpen")

Found the issue!