Update Field using a calulation

[waylander32]

Hi
I need the data for a field to be calculated from 2 other fields

so the user enters for example the start time and finish time the db then calculate the differance and put that in another field which the user can see on the form..

I know best practise is to use reports and queries for this but I want teh number to be put in the table so I can use elase were without having to use calculations etc..


I did a work around by using an update query and a macro - then enteredthe macro in the event section of the field properties.


It worked but wouldn't update the field on the form you had to go out and back in

any ideas

 

[boblarson]

1. Putting a calculated value in a field when you have the parts to do the calculation is just not right. It does violate the rules of normalization and you cannot ensure data integrity unless you are using Access 2010 with a data macro.

2. You should just make a base query which has that calculation as well as the other fields and then you can use it in 99% of the places you would use a table.

 

[waylander32]

Thanks for the advice it worked a treat