>Q was just an example (as I didn't know the name of your query). Use the
>name of your query (esitest)!!!

Doh!  Got it.

>Are you sure adding SUM(DATEDIFF('n', confhrsfrom, confhrsto)) in your
>select doesn't work?

I get zero when I sum.

>Although it looks like the SUM functions won't do much, as your group by
>will probably return individual records.

You're right here!

>
>I think you may need two queries here. What are you trying to achieve?

Just trying to sum the total hours column of data.

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

Reply via email to