Continuous Form Summing to text box from query results.

[november]

My db tracks supplier cost changes for our annual deadline.

I use Dsum in text boxes to calculate the COGS * the % in/decrease.

I have a textbox in the header that will give Total COGS.

dsum doesn't work, I found that out and I don't know how to get sum to work.

Current controlsource for txtSUMofTotalCOGS is this:

=DSum(qryPMDetails![Total COGS Annualized],[qruPMDetails],qryPMDetails![Product Manager]='" & [Forms]![frmMainMenu]![cboPM] & "')

What I hoped to get with this was it taking the cogs coming from the query and summing them up.

That didn't happen.

The txtbox that shows the sum for each line is txtTotalCOGS.

Please help if you can, thanks.

 

[jal]

I have no idea, but I'm guessing this word is a misspelling in your DSUM:

qruPMDetails

 

[november]

My mistake, that was the forumula I was originally using.

I really don't know how to get it to sum to all fields showing from the query.

 

[jal]

Is it throwing an error? Is it giving you no value at all?
What value is it giving you?

 

[november]

I believe with Dsum originally I was getting ?Name#

But when Summing I got it to display the sum of whatever value I clicked on, I guess that's progress, but not enough.

 

[jal]

What exactly is "not enough." I can't help you until I know exactly what the problem is.

 

[november]

I have a textbox in the header, I'm unable to make it display the SUM of COGS in the continuous form below.

 

[jal]

I've never used continuous forms so I doubt I can solve this. I'm sorry.

Just to clarify, though, the DSUM is calculating the correct value, and you are able to display the calculation in the header, but not in the actual form?

 

[november]

I'm going to have to go back and retype my initial post.

Dsum isn't giving me Aggregate COGS at all. Dsum is only calculating the COGS per line displayed by the query.

I have a textbox in the header of this form and I want to display an aggregate/sum of all cogs for that product manager listed below.