(Not that I use access a lot). You can always calculate the sum in CF.
<cfset sum = 0>
<cfoutput query="q">
<cfset sum = sum + Val(q.no_of_minutes)>
...
</cfoutput>
> -----Original Message-----
> From: hammerin hankster [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 1 juni 2004 16:15
> To: CF-Talk
> Subject: Re: SUM/Convert string numeric data
>
> >What DB? Normally, datediff returns an integer that you can happily
> >SUM().
>
> Access.
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
