A MATCH function for Access?

[Access_Novice]

In the attached database, I have two simple tables. One contains timesheet data and the other defines each person's labor category and the effective dates of any labor category they are assigned to.



I am trying to create a query that will pull the timesheet data, compare it to the LaborCat file, then determine if the labor category in the timesheet file is correct or not, based on the timesheet date.

For example, on 07.05.2014, Howard Hughes is a Software Engineer II. But according to the LaborCatFile, he should be a Software Engineer I, because 07.05.2014 falls BETWEEN 05.01.2014 and 07.31.2014.

Excel has a MATCH function which works vertically. Does Access have a similar function which can work horizontally across the Start and End columns of the LaborCat file?


I just don't know where to start.

[June7]

No.

Have to build expression in query that compares data or do a Find Unmatched query or build custom function.