smtazulislam
Member
- Local time
- Today, 18:27
- Joined
- Mar 27, 2020
- Messages
- 806
Hey access all experts,
I have a database but before I have to entry Payroll Or Salary Transfer in an excel sheet, now I like to update data in access database.
So, I needs your help that, these table how can create easily query and form for easy to entry data and search,
NOTE: if any expert want to modify allowed.
Many Thanks
tblAbsentDates
tblAllowanceData
tblContract
tblDeductionProcedure
tblPayroll
tblStopSalary
tblBankTransfer
===================================
in this tblTransactionWorkers little criteria like :
TransferDate- If same EmpleeID will transfer another company then status text should change automatic Transfer And LeaveDate field - change last date of transfer
Please see here tblTransactionWorkers
I have a database but before I have to entry Payroll Or Salary Transfer in an excel sheet, now I like to update data in access database.
So, I needs your help that, these table how can create easily query and form for easy to entry data and search,
NOTE: if any expert want to modify allowed.
Many Thanks
tblAbsentDates
tblAllowanceData
tblContract
tblDeductionProcedure
tblPayroll
tblStopSalary
tblBankTransfer
===================================
in this tblTransactionWorkers little criteria like :
TransferDate- If same EmpleeID will transfer another company then status text should change automatic Transfer And LeaveDate field - change last date of transfer
Please see here tblTransactionWorkers