David and Jamie,

Many thanks for your help on this matter.  During the last two days I have made progress eliminating this and that using some of your expertise as a...

Thanks again David.  My problem is mapping the variable, but again let me try and clarify.  In DTS 2000 I would create a variable and assign a value. In a...

Thanks for your swift response David but perhaps I should add some supplementary information.  In the Control flow all is well up to and including the variable assignment (I have...

One of those - "Doh, Why didn't I think of that?"  Simple and smart - well done.

Some interesting points in a good article.  Regarding "Most managers, shareholders, etc. will put up with pretty much anything from someone if that person is generating revenue.", reminded me of...

I agree with Clinton - should have called it 'How to mess up an Article'.  The whole subject of blessing and cursing is irrelevant - don't do it!  We are...

I don't think Go is necessary after each statement.  I agree SP is the way to go with your conditional.  I check for table existence many times in SPs before...

I assume that your total time spent formula is something like Sum(CallID) which would be the grouped total.  To convert to H:mm use something like this instead of the Sum(CallID):

=Int(Sum(CallID)/60)...

Hello Ruud,

It is a member server.  Another thing I tried to see what the results were was to email myself a subscription to a report daily.  I get the email...

I like the coalesce. Nice and succinct, and from a newbie ?!

Added later:  Whoops! Didn't mean to call you a newbie - just realised that Newbie refers to how many...