Hi all,

In a table having three fields like
CallStart    (data like 6/18/02 9:26:12 AM) date/time
CallEnd      (data like 6/18/02 9:33:48 AM) date/time
CallDuration ??    

How can i update callduration field with the duration (callstart-callend)

Thanks in advance for any help.

If the ColDuration is a Date/Time field:
UPDATE Tablename SET CallDuration =CallEnd-CallStart
(however the result will have a 1:29am 12:00pm, 3:00pm for 1:29, 12hours, 15hours)

If the field is numeric, it'll be a decimal point.

Or you could open the table, get the values from CallStart & CallEnd and subtract them via DateDiff, and then store the value in the table.

The last method requires looping through the table.