How do you tie in information from a second table into a query?

[jarl97]

I have developed an Access 200 database to track labor on multiple projects. I generated a table to capture the labor entries with hours, project numbers and dates.

I, then, developed a query to give the total for each project for each day during an entered time period.

I have in the database an average labor rate table with effectivity dates. I would like to have the above query pull the average labor rate, for the given day,and add it to its output. Is this possible?

Thanks