| |
You are here: Experts > Computing/Technology > Business Software > Using MS Access > MS Access - Formula text boxes storing results in table
Expert: Scottgem
Date: 9/5/2008
Subject: MS Access - Formula text boxes storing results in table
Question
I am designing a database for a small company that requires to store and print invoices.
I have designed the form and have entered formulas in the Net, VAT & Total text boxes to make it easier for the user. The problem i am having, is the amounts e.g. net, vat & total for each invoice are not being stored in the Invoice Table.
How do i produce the form so it calculates the amounts itself and stores the results in the correct fields in the table?
Answer
You don't. As a general rule we do NOT store calculated values. You can use the same expressions you have to calculate those values wherever you need to display them. Only the components of the calculation need to be stored, not the results.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
Add to this Answer
Ask a Question
|
|
