Thanks!
> 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]
