Hi,

I have 2 columns - ScanDateTime and DataDateTime and both are DATETIME fields having values as given below..

ScanDateTime DataDateTime
2009-10-21 08:51:22 2009-10-21 09:53:16
2009-10-21 10:19:27 2009-10-21 09:53:16
2009-10-21 10:19:27 2009-10-21 10:44:50
2009-10-21 10:44:50 2009-10-21 10:59:33
2009-10-21 10:59:33 2009-10-21 09:18:53

Now I want to add all the value in ScanDateTime field and in DataDateTime field such as..

Code:
Value = (Sum of timestamps for ScanDateTime + Sum of timestamps for DataDateTime)
And Divide the data returned from Value by a Number ( say 1000).

How can this be acheived ??

Thanks.