Updating calculated fields in access
On this page Allen gives some tips on calculated fields that may help, especially if you decide you do want to store it and use Access 2010 (I'm only on 2007...).As for your question, you still didn't tell me where your error was so it is hard to pin-point the issue.For this i have created a Form to input the no of days present and calculate the earned salary based on the input.
Note Microsoft Share Point Foundation formulas for calculated fields are based on Microsoft Excel functions and syntax.
For example, January 1, 2007, is represented as 2007001 and December 31, 2007, is represented as 2007365. To convert a date to a Julian date, use the TEXT and DATEVALUE functions.
You can use the following formulas to perform a variety of mathematical calculations, such as adding, subtracting, multiplying, and dividing numbers; calculating the average or median of numbers; rounding a number; and counting values.
Who takes 7 seconds to develop,7 mins to document,7 hours to test,7 months to fix will always blame the clock.
If you are building an Access form based on a query and notice you will need to add a calculated field, you don't need to redesign your query — just add the calculated field to your form.