SUM/Convert string numeric data

[hammerin hankster]

I'm doing a DATEDIFF on a range of times and then displaying the result wiht a VAL function to convert the minutes to hour increments:

DATEDIFF('n', confhrsfrom, confhrsto) AS no_of_minute
#Val(no_of_minute) / 60#

However, I need to total the column of minutes but since it's not a numeric value, SUM is returning 0.  Any suggestions on how to fix this?  

(FWIW, I've inherited this database, didn't design it.)

Thanks

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---