please help, time sensitive

[Guest]

I have a table that has a start time, end time, and call length. Whats the
best way to have access fill in the [call length] feild with the elapsed
time? The time will NEVER start on one day and end on another. Longest all i
have ever sense is about an hour.

 

[Rick Brandt]

I have a table that has a start time, end time, and call length. Whats the
best way to have access fill in the [call length] feild with the elapsed
time? The time will NEVER start on one day and end on another. Longest all i
have ever sense is about an hour.

The "best" way? Remove call length from the table and calculate it on the fly
on your forms, reports, or in queries. Derived values should NOT be saved.

Use DateDiff() to calculate the difference in seconds and then do some math to
get minutes and seconds.