Very Beginner Question

[benlaird24]

Hi this should be very simple, but it's not for me.
I am creating a database logging machine error's.
Each error has a recorded start and end time, which I enter.
I want the database to enter the elapsed time into a third field, 'ElapsedTime'.
I see how to do this in the builder, just subtracting the two fields. But I know not to make it a condition of my query, that doesnt make sense. Where do I put my expression so that my table updates itself with the new field?

Thanks!

 

[RV]

You don't store calculated values in tables.
Use a query.

RV

 

[benlaird24]

How though?
What kind of query should I use, and where does the expression go?

 

[thalam]

How though?
What kind of query should I use, and where does the expression go?

Your not supposed to store values that can be calculated, but if u are u can use an update query and say something like

Elapsed: EndTime-StartTime in the update to line i think.