How would I write the sql code to total the row? Total Hours Worked?

Answer

Oops.. --------------------------------------------------------------------------------------------------- UPDATE [MyTable] SET [HoursWorked] = ( IIF(ISDATE(NZ([TimeOut1],'NO')),DATEDIFF('n',[TimeIn1],[TimeOut1]),0) +
Q&A Related to "How would I write the sql code to total the..."
Bear Down is an idiot who will say anything if he thinks it helps his argument.
http://answers.yahoo.com/question/index?qid=201202...
Before using Total SQL Statistics programmatically, you should understand how it works, and where it keeps its scenario settings. Total SQL Statistics is written entirely in Visual
http://www.hallogram.com/sqlstatistics/index.html
I discussed the selectivity of a query. Today I will further extend our discussion and will drill down how index Statistics works. I will continue it in my next article where we will
http://sqltips.wordpress.com/2008/07/17/how-sql-se...
About -  Privacy -  AskEraser  -  Careers -  Ask Blog -  Mobile -  Help -  Feedback © 2014 Ask.com