Sum Different Fields Error

[senn2912]

Hi,

Can someone please help?

I am trying to sum 3 different time fields together in a report that all are the same format but it wont allow me to.

The expression i have built is =Sum([ACDTime]+[AgentRingTime]+[OtherTime])

but I get back a error message saying...

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

Can anyone please advice the best way to combat this?

Thanks,

G

 

[Pat Hartman]

The Sum() function sums rows NOT columns. If you want to add columns together, you don't need a function.

=[ACDTime]+[AgentRingTime]+[OtherTime]

If any of the operands may be null, you will need to use the Nz() function.

=Nz([ACDTime],0)+Nz([AgentRingTime],0)+Nz([OtherTime],0)