I have calculated fields that show the calculated data when i run a query or report.
But then the data is not saved in the tables. how do i ensure that data is saved in the tables.
I have calculated fields that show the calculated data when i run a query or report.
But then the data is not saved in the tables. how do i ensure that data is saved in the tables.
Saving a Calculated data is not recommended, however with a little of VB could do the work for you