Hi
Appreciate if someone could help me to resolve the following issue.
I have a timesheet table with the following fields
EmployeeID
Week_Ending_Date
Location
Hours
Each location has a charged out rate which vary at differen date range. For example
Location Date From Date To Rate
Area A 1-JUL-2009 31-DEC-2009 $60
Area A 1-JAN-2010 30-JUN-2010 $65
Area A 1-JUL-2010 31-AUG-2010 $67.50
Area B 1-JUL-2009 31-DEC-2009 $40
Area A 1-JAN-2010 30-JUN-2010 $48
How do i return a rate value for each timesheet line in my query?
Thanks