Adding DSum

N

NNlogistics

I want to add to different DSum's and divide by the sum of two DCounts. I
started by just adding two DSums and getting error(#Name?).
=DSumAvg("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTime")+DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate")

My guess is bracketing?

or do I have to use 4 different text boxes - make them invisible and do the
math from those boxes?
 
J

John Spencer

What is DSumAvg ?

Perhaps what you want is
=DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTime")
+
DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate")

IF you want the Average of those 2 values then divide by 2
=(DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTime")
+
DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate")) / 2

Note the inclusion of a new set of parentheses. That is to ensure the order
of operation. Without the parentheses the 2nd DSUM would be divided by 2
and then added to the 1st DSum.
 
N

NNlogistics

Dah! I'm Sorry DSumAvg was a typo.Thankyou that fixed it
I beleive(other than DSumAvg) I had the same syntac
--
Thanks for any assistance


John Spencer said:
What is DSumAvg ?

Perhaps what you want is
=DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTime")
+
DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate")

IF you want the Average of those 2 values then divide by 2
=(DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTime")
+
DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate")) / 2

Note the inclusion of a new set of parentheses. That is to ensure the order
of operation. Without the parentheses the 2nd DSUM would be divided by 2
and then added to the 1st DSum.

NNlogistics said:
I want to add to different DSum's and divide by the sum of two DCounts. I
started by just adding two DSums and getting error(#Name?).
=DSumAvg("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTime")+DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate")

My guess is bracketing?

or do I have to use 4 different text boxes - make them invisible and do
the
math from those boxes?
Click to expand...
Click to expand...
 
Top