If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding 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]","qryCollateraQualityListPartsShippedTurnaroundTi me")+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? -- Thanks for any assistance |
#2
|
|||
|
|||
Adding DSum
What is DSumAvg ?
Perhaps what you want is =DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTi me") + DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate" ) IF you want the Average of those 2 values then divide by 2 =(DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTi me") + 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" wrote in message ... 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]","qryCollateraQualityListPartsShippedTurnaroundTi me")+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? -- Thanks for any assistance |
#3
|
|||
|
|||
Adding DSum
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" wrote: What is DSumAvg ? Perhaps what you want is =DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTi me") + DSum("[TurnAroundTime]","qryBillableQualityListRepairsShippedByDate" ) IF you want the Average of those 2 values then divide by 2 =(DSum("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTi me") + 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" wrote in message ... 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]","qryCollateraQualityListPartsShippedTurnaroundTi me")+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? -- Thanks for any assistance |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dsum return 0 instead of Null? | HB | Running & Setting Up Queries | 6 | September 18th, 2008 10:48 PM |
DSUM Criteria in a Report | colin | Setting Up & Running Reports | 4 | September 10th, 2007 09:38 PM |
DSum on a report | BrianS | Setting Up & Running Reports | 5 | March 18th, 2005 01:45 PM |
DSUM and DCount when criteria values are similar | BAC | Worksheet Functions | 1 | February 14th, 2005 06:38 PM |
Doing a DSUM for specific creteria | Marcel Beaulieu | Worksheet Functions | 2 | October 6th, 2004 01:07 PM |