Field Total Question

[AccessRookie]

I have a field called "Write Down" and is a Dollar amount.

=([ORIG PRICE]*0.85)-([total cost])

The value above is how this Field is calculated.

How do I tell it to "only" Total the 'negative' values?

I do not any 'positive' values totaled for the Total Write Down calculation.

Thanks!

 

[jdegeorge]

Did you try

=iif([Write Down]>=0, sum([Write Down], "&quot

as the value of your total field? Didn't try it mysel.f

Jim DeGeorge

 

[dhookom]

I assume Write Down is a text box not a field since you used "=". One solution is to create the extra column/field in your query:
WriteDown[ORIG PRICE]*0.85)-([total cost])
Then in your report, use a text box in the report footer with a control source of:
=Abs(Sum([WriteDown]<0 * [WriteDown]))

Duane
MS Access MVP

 

[AccessRookie]

Thank You Very Much Duane!

It's simple things like the ABS formula that makes it so much easier!

Thank you!!