Update table from calculated field in a form

[BernardKane]

I have a simple database that records my hours worked and associated income against my hourly cost.



I have two fields with derived data that calculates the overall time to do the job (=GetElapsedTime([Finish]-[Start])) and the value of the time calculated from value of hours and minutes (=([Hours]*[ValueHours])+([Minutes]*[ValueMinutes])). How do I get the results calulated to automatically update the table that houses the fields for these two derived pieces of information. At present I use SQL from an update quesry set in a macro but it is not very effective.

Any help would be very much appreciated. I fairly new at this sort of thing so clear advice would be very gratefully recieved.

Bernard Kane

[Tanis]

An update query is the way to go, but in all honesty, you should not put derived data in a table. It is considered bad practice, as you can always get the answers through a query. I would try to steer clear of macros anyway. You should trigger the calculation in either a form event or a control event, say behind a command button.

[BernardKane]

Thank you for that but I was hoping there was a way of coding an update to a table without using a query.

Bernard

[Tanis]

You could use SQL?