DSUM report (1 Viewer)

M

mveijndh

Registered User.

Local time

Today, 09:59

Joined

Dec 17, 2011

Messages

113

• Mar 2, 2016

• #1

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?

Code:Copy to clipboard

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

Thanks in advance

 

C

cyanidem

Nieóhfytny jaszczomp

Local time

Today, 17:59

Joined

Nov 30, 2015

Messages

106

• Mar 2, 2016

• #2

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

Code:Copy to clipboard

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

 

J

JHB

Have been here a while

Local time

Today, 18:59

Joined

Jun 17, 2012

Messages

7,732

• Mar 2, 2016

• #3

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

 

M

mveijndh

Registered User.

Local time

Today, 09:59

Joined

Dec 17, 2011

Messages

113

• Mar 2, 2016

• #4

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?

 

M

mveijndh

Registered User.

Local time

Today, 09:59

Joined

Dec 17, 2011

Messages

113

• Mar 2, 2016

• #5

Hi,

I've changed the DSUM to:

Code:Copy to clipboard

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

Found the issue!

 

Last edited: Mar 2, 2016