VB Question - Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm wanting to sum the fields [Calls_Ans] and [Calls Offd] then do the
division. Can someone tell me how to do this?

Select Case App_ID

Case Is = 10089 Or 10107
Vol_AHT = ([Calls_Ans]) / ([Calls_Offd])



Many thanks if you can help!
 
hi Stan,
I'm wanting to sum the fields [Calls_Ans] and [Calls Offd] then do the
division. Can someone tell me how to do this?

Select Case App_ID

Case Is = 10089 Or 10107
Vol_AHT = ([Calls_Ans]) / ([Calls_Offd])
Click to expand...
Use DSum(), e.g.

DSum("([Calls_Ans]) / ([Calls_Offd])", _
"yourTableOrQuery", _
"[App_ID] IN (10089, 10107)")


mfG
--> stefan <--
 
Still getting an 'Argument Not Optional' error message. Below is the
complete function. Any ideas?


Function Vol_AHT(App_ID, Calls_Ans, Calls_Offd)

Select Case App_ID

Case Is = 10089 Or 10107
Vol_AHT = DSum("[Calls_Ans]") / ("[Calls_Offd]")


Case Else
Vol_AHT = "No Data"

End Select
End Function

Stefan Hoffmann said:
hi Stan,
I'm wanting to sum the fields [Calls_Ans] and [Calls Offd] then do the
division. Can someone tell me how to do this?

Select Case App_ID

Case Is = 10089 Or 10107
Vol_AHT = ([Calls_Ans]) / ([Calls_Offd])
Click to expand...
Use DSum(), e.g.

DSum("([Calls_Ans]) / ([Calls_Offd])", _
"yourTableOrQuery", _
"[App_ID] IN (10089, 10107)")


mfG
--> stefan <--
Click to expand...
 
hi Stan,
Still getting an 'Argument Not Optional' error message. Below is the
complete function. Any ideas?
Click to expand...
Use the immediate winow:

? DSum("([Calls_Ans]) / ([Calls_Offd])", _
"yourTableOrQuery", _
"[App_ID] IN (10089, 10107)")


mfG
--> stefan <--
 
Back
Top