kfschaefer1
New Member
- Joined
- Feb 28, 2016
- Messages
- 9
What is the correct syntax for the following situation?
I have two tables ResPlanData, SalaryEmpDetail
I need to look up the salary value for those employees who fall under the following criteria.
Name matches in ResPlanData, where ResourceType ="Salaried W/2"
If StartDate is prior to current year start then divide the salary amount by 12, else
use Start Date(first of that month) to input the Salary amount for remaining year.
if matching first 3 criteria then replace the Value where ResPlanData.[Resource Rate]="Billing" and ResourceType ="Salaried W/2" for employee and corresponding date.
.
I have two tables ResPlanData, SalaryEmpDetail
I need to look up the salary value for those employees who fall under the following criteria.
Name matches in ResPlanData, where ResourceType ="Salaried W/2"
If StartDate is prior to current year start then divide the salary amount by 12, else
use Start Date(first of that month) to input the Salary amount for remaining year.
if matching first 3 criteria then replace the Value where ResPlanData.[Resource Rate]="Billing" and ResourceType ="Salaried W/2" for employee and corresponding date.
.
