Inserting Data in table

Adeola

New member
Local time
Today, 06:54
Joined
Nov 9, 2013
Messages
9
Hi Every body i am new to Access and i am designing a payroll system for my company.
I have created a Table with EMP Id,Name,Basic Pay,Total Working Days,Actual Work Days,Earned Salary,OT days,OT Hrs,OT Pay.........
Now i have created a form with all the above fields.and calculated the earned salary from the control source where Earned Salary= Basic pay / Total Working Days*Actual Work Days and OT Pay =[Basic Pay/Total Work Days/8]*150%*OT Hrs.
Now my problem is i am not able to populate the fields in the table and can you please help me for the OT Pay calculation also.I will be very much thankful if anybody can help me.
 
Did you set the Source of the Form as your Table then drag on the Fields?

Or did you click on the Table and select Create Form, this will auto bind it.

Or did you just create a Blank New Form?
 
@ ALex I have clicked on the create a form and automatically all the fields in the table have been populated.
 
Ok, so you open the Form, you start typing in your information, are you getting any error messages?
This should allow data entry.
 
Not sure that you (both of you) are on the right track.
First of all, NEVER NEVER EVER store a calculated value in a table.

Then, from what you describe, Adeola, in your first post, I'm pretty sure that your DB is NOT normalized.
In a well normalized DB is very rarely to have tables with so many fields.
Google a bit and learn about DBs NORMALIZATION.
After this come back and ask again :)
 

Users who are viewing this thread

Back
Top Bottom