pull information from a field in another table from the respective field based on the month of the year

Sergio

I read your question again.

The best way to do the tables is to have a separate record for each month in the interest rates table. Set the key field to be a date field type and enter the date for the first of the month in each record along with the interest rate.