I have a form name frm_BrowseAdd with a txtbox named % Viable the value in the field was originally static but I want to store it in my table: tbl_U2_Spinners ! UserVar07.
% Viable is calculted from 2 txt boxes a the form. txtViable and txtTotal.
% Viable = [TxtViable]/[TxtTotal]*100.
TxtViable and TxtTotal are stored in tbl_U2_Spinners. How could I create a procedure mabey an after update that would store this value in my table. Or calculate it from the data that already exists in my table?
It would be good if I can back calculate all of the existing data..
Can anyone help?