SUM().
> -----Original Message-----
> From: hammerin hankster [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 1 juni 2004 15:30
> To: CF-Talk
> Subject: Re: SUM/Convert string numeric data
>
> Any ideas on this?
>
> 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]
