raziel3
Registered User.
- Local time
- Today, 10:08
- Joined
- Oct 5, 2017
- Messages
- 273
Good day everyone, I am searching for a method to track employee loans. I have an Employee Loans Table with the fields and data:
EmpName - John Doe
LoanStart - 5/1/19
LoanEnd - 6/30/19
LoanAmt - 800.00
RePmtAmt - 200.00
RePmtTerms - Fortnightly
On my Payroll query I am trying use a Dlookup to return the RePmtAmt for John Doe for Payroll Period Ending 5/31/19.
Using This:
but PeriodEnd is a field in the Payroll Query not the Employee Loans Table so how I 'switch around' the criteria, is it possible or am I approaching this wrong?
EmpName - John Doe
LoanStart - 5/1/19
LoanEnd - 6/30/19
LoanAmt - 800.00
RePmtAmt - 200.00
RePmtTerms - Fortnightly
On my Payroll query I am trying use a Dlookup to return the RePmtAmt for John Doe for Payroll Period Ending 5/31/19.
Using This:
Code:
DLookup("RePmtAmt","
tblEmpLoans","[PeriodEnd] <= " & [LoanStart] & " And [PeriodEnd] >= " & [LoanEnd])
but PeriodEnd is a field in the Payroll Query not the Employee Loans Table so how I 'switch around' the criteria, is it possible or am I approaching this wrong?