Multiple criteria lookup

[rchtan]

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

[pbaldy]

Search on the non-equi join. Here's one relevant thread:

https://www.accessforums.net/queries...bles-4952.html

[rchtan]

Thanks for the info

[pbaldy]

No problem, and welcome to the site. Did you get it working?

[rchtan]

Yes after many attempts