Adding DSum

[Guest]

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?

 

[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.

 

[Guest]

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

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.

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?