SUM of all fears

[dkuntz]

I keep getting a data type mismatch when I attempt to sum time values. I need to total the amount of time each saleperson spends per phone call.

i.e
call 1- 00:01:00
call 2- 03:05:00
call 3- 00:22:50

Total- 03:28:50 (this is where I need help)

I know there is an expression that can do this but I am not for sure how to go about writing it.

Any help is always much appreciated!

Thank you -

Derek

 

[fernin8r]

What function are you using right now?

 

[fernin8r]

I'm not very familiar with Time, but i think if you set the Control Source for Total:

= DSum([Call], "Table1")

I think that should work. It will add up the total time in the Table1 (or whatever you called it) field [Call].

 

[dkuntz]

Thanks for your reply but I got a syntax error:
syntax error in query expression 'First([DSum([DURATION],"ContHist"])'


[DURATION] is the name of the field.

I am trying to do this on an unbound textbox in a group footer.
Before I was trying =Sum([DURATION]) to no avail.

 

[dkuntz]

Tried running it again and I am getting "error" in the textbox

 

[fernin8r]

You may not be able to use the DSum function with time. (I was unsure). I tried looking up something on Summing Time in the help menu and Queries came up.

Look into it. Go to the help menu and use the find tab to search for "sum time". i hope this helps.

 

[Pat Hartman]

Is the duration field defined as text or date/time? Summing elapsed time is tricky since date/time fields are intended to store a tme of day rather than elapsed time. There are many solutions here. Try the search.

 

[dkuntz]

Duration is stored as a text.

I'll find a solution sooner or later.

Thanks Pat