Thread: Urgent please need help.
11-08-13, 15:51 #1Registered User
- Join Date
- Nov 2013
Unanswered: Urgent please need help.
I am very new to this Acces.I am trying to design a payroll system.
I have Created an Employee table with the following fields :EMP Id ,Name,Basic Pay,Total Working Days in a month,Actual Worked Days ,Earned Salary.
Now i have created Form with all the fields in the Table and am calculating the Earned Salary using Control source using Earned Salary=BasicPay/Total no of working Days in month* Actual Working Days.
Now i want to populate this calculated field in the table. I will be giving the Actual Days as input on the form because this value will be changing for employees based on their Days present.So,Can you please help me out.
11-09-13, 15:56 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
Storing calculated values, in a Table, is seldom appropriate, with only a few specialized exceptions, and this scenario is not one of those. They should simply be re-calculated, as needed, in Forms, Queries or Reports.
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007