I want to populate an underlying table (in MS Access 2000)with the results from a calculated field.The main purpose is to store the calculated data for reporting purpose.Currently,I can only get the calculated data at the form level ,but it doesnt stored in the table hence I cant get the correct records through queries.
any help please???