populate a column with time from other column.

[EM1107]

Good day

I am new to MS Access and I need to create a table where the value that should be inserted in the column is the time calculation of two other columns.

So I have a table with 3 columns.

Start_time, Stop_time, TIME_SPENT

When I insert my start time and stop time I want the Time_SPENT to actually be a time difference between the start and stop time.
In other word I want to know how long I spent on that entry.
How can I configure MS Access to populate that column with that time spent?

 

[Andrzejek]

Do NOT keep your calculated value in a 'regular' column in a table (the way that you can enter any value in this new column)
Either:
Create a view and use DateDiff Function to calculate the 'time spent'

Or - better yet - use a Calculated fields in your table

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson