Expression Builder Help

[Vibhor]

Hey


I need help in the following scenario:

Table: EmployeeDetails
EmployeeName DailyWage Attendance Salary

Form:EmployeeForm
EmployeeName DailyWage Attendance Salary

Now, when i open this form, I enter details as:
XYZ 180 30

Now I want that the form should calculate and store the value automatically. So in Control Source of Salary i wrote =[DailyWage]*[Attendance]
Its displaying the multiplication correctly but not storing in the database. Pls guide me how to do so.


Vibhor

[June7]

Storing calculated data is usually unnecessary and often a bad idea. This value can be calculated when needed. Storing the calculated data will require code.

[Vibhor]

This problem has been simplified for asking. But what if there is a need to store this value?

[orange]

I recommend you work through this tutorial. It will lead you through the processes of database design, normalization and relationships.

Good luck with your project.

[June7]

Use code. I use only VBA but macro can do same with SetValue.

The real trick is figuring out what event to put the code in, perhaps in a button that closes the form (then you really should disable the form X close).

Me!Salary = Me.Salary