I have an Access database with a table titled products. I want to multiply two fields automatically. One field contains the price of a product (pPrice), and the other field contains the amount of units remaining (plnStock). I want the results to reside in a field (currency) titled pTotals.
What is the best way of accomplishing this? Can this be done automatically inside Access? If so, how? What specific steps are taken to accomplish this?