waylander32
Registered User.
- Local time
- Today, 06:59
- Joined
- Oct 20, 2010
- Messages
- 20
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
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