Looking for direction on the best way to select the correct value -

I have three simple tables to track tasks by resources. the tables are set up for 1) resources - this contains names and a labor category assigned to the resource 2) labor rates - this is done by year (as the rate changes by year), and labor category 3) time - this contains the date, hours and resource.
I am trying to create a report that that will calculate the total rate based on the hours, date [year] and resource.
when i write the report, the data returned as duplicate rows, because of the rate factor.


sample
1) resource
resource_name1
labor_category
2) labor_rates
labor_category -links back to the resource
year
rate
3) time
resource - links to the resource table
date
hours