Help! Not sure how to do this

[ineffable888]

Hello Everyone,

Background: I am currently building a payroll database for one of my clients and I encounter a roadblock of which If not solved, will halt my progress.

The problem is, the employee's hourly rate changed. Let us say, Employee A's rate changed from $5 per hour to $5.50 per hour beginning Nov 1, 2013.

I am not sure how to do this in Access.

I tried putting up a database named db_EERates with the following fields ID, EEID (for Employee ID), Rate (Amount), Effective Date and End Date.

Now on a DTR (Daily Time Record) query, I have a the following fields, ID, EEID (for Employee ID), Payroll Period, Date, IN, OUT, Total Hours, Rate, Total Pay.

I want the Rate field to show the Employee's Hourly Rate based on the Date. However, I am having problems doing so..

How do I do it?

 

[JHB]

I tried putting up a database named db_EERates with the following fields ID, EEID (for Employee ID), Rate (Amount), Effective Date and End Date.

Another database or a table in the current database?
You must link the tables together with the relevant fields in the Query, (use the QBE-window).
What is "Effective Date" and "End Date" for, (is one field not enough)?
If you can't get it, then post a stripped version of your database, with some sample data, zip it then you haven't post 10 post yet.