RecordSET under the YEAR and Month.

[arnelgp]

i want you to do something on the attached db:

1. on table tblEmployeeSalaries, fill-up MOnthYear field.
2. on table tblDeductionProcedure fill the "Year" field.

because most of your data don't have Date so
it is hard to distinguish which month-year (payroll period) does
each record belongs.

when you are done with the 2 above. post your db.

 

[smtazulislam]

i want you to do something on the attached db:

1. on table tblEmployeeSalaries, fill-up MOnthYear field.
2. on table tblDeductionProcedure fill the "Year" field.

because most of your data don't have Date so
it is hard to distinguish which month-year (payroll period) does
each record belongs.

when you are done with the 2 above. post your db.

Thank you so much. I will check and give you reply as sooner.

 

[smtazulislam]

Any one can help ????

 

[smtazulislam]

Hello,
Can you anyone give me payroll system by keep data month and yearly.

 

[smtazulislam]

Hello I want to update my PayRoll system.
In the picture, you can see the RED marked a query like
if tableA data doesn't match with EmployeeID & Month & Year then Insert value is "0"

How can do that?

 

[smtazulislam]

Does any help please?

 

[smtazulislam]

any help.... ?