Calculated Text Box Populating in Table

[Debbie]

:roll: I know this has to be an easy question... I'm new to Access. How do I get a calculated text box on a form to populate in the database table. Ex. I have a column called "calculated time" in my time sheet table. On my form I have entered...=format([TimeIn]-1-[TimeOut],"short time").
This formula does exactly what I need. How do I get the answer from this formula to populate in the "calculated time" column in my table.

I hope this makes sense.

Thanks in advance for any help.



Debbie
deb@harder.us

[matthewspatrick]

Debbie,

The best answer is: don't!

Seriously, it is usually a bad idea to store derived values in your database. The best practice is to calculate derived values on demand in your queries, reports, and forms.

[Debbie]

Thanks very much. I will do that.