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