Help with DSum Function

[robotpoop]

Hi everyone.

I have one query (we'll call it Query A) that identifies transactions on an account based on certain criteria.

In a second query (Query B), I'm attempting to use DSum to pull in the total of the transactions from Query A, but whenever I run it I'm prompted to enter a parameter value.

Here's what I'm using as my expression:

Expr1: DSum([TRAN_AMT],[Query A])

What am I doing wrong? I've never used DSum before, so I'm expecting that I've overlooked something obvious here.

 

[xenou]

Usually this means a typo (you spelled something wrong or referenced a field/table that doesn't exist in the data source). Also be aware that prompts for a parameter can be in a query or any query called by that query -- so the problem could be in Query A, not Query B.

You might need to provide more information. On the surface, the syntax looks fine but of course it isn't - so there's more to the story.

 

[robotpoop]

Here's the actual expression:

DSum([dmd Previous Curtailments]![TRAN_AMT],[dmd Previous Curtailments])

 

[xenou]

Okay, well that now looks less certain because the third parameter possibly has wrong syntax. Are you meaning to apply a criteria? What is the criteria supposed to do?

See here for a full description of DSUM:
MS Access: DSum Function

 

[robotpoop]

There's no criteria.

[dmd Previous Curtailments]![TRAN_AMT] is the field that I wish to sum, from the other query.

[dmd Previous Curtailments] is the other query.

 

[Joe4]

Syntax is important. Looks at how it is written in the link xenou provided.
Try:

[COLOR=#333333]DSum("TRAN_AMT","dmd Previous Curtailments")[/COLOR]

 

[xenou]

Joe's syntax is correct. You can just use the string literals as in Joe's example and it will return the sum you want.

Post back if that's not sufficient (i.e., I could think of example where you are using form fields to sum different fields at different times so you want the user or some other procedure to dynamically alter the inputs to DSUM.