Update Field in Table From another Table

[mone76]

I have a training Database in Access 2010 that I am creating. I have ‘courseindex’ which is the table that has course titles and the course required frequency. I also have ‘trainingcompleted’ which is the table that contains all training my employees have completed. I need to be able to pull the frequency from the ‘courseindex’ table to the ‘trainingcompleted’ table. I want the Frequency field to update based on the Course field.



I’m not sure how to get this accomplished. I have attached a photo of both tables.

[JoeM]

I don't see a need to update the one table from the other, when just a simple query between the two tables will do.
Just join the two tables on the "Course" fields, and return the fields from each table that you want in the query.

[mone76]

I can't get it to do what I need it to do. I need to be able to generate a report on which employees are due for training. It is not pulling the frequency over. We have well over 1,000 employees that take any number of the given training. I need to be able to enter the date range needed (I have the query for that) and a report generates that shows which employees are due for training during the time-frame. I attached the query I already have for the report. Can I make adjustements to it in order to get the results I need in my report?

[mone76]

Nevermind! I think I got it!

[JoeM]

Nevermind! I think I got it!

I am guessing that you figured out that you just need to add your other table to your existing query (joining on the Course field) and adding that other field you need to the query results...

[mone76]

Yes. I have been overthinking it. This database has been a nightmare! Thank you for your help!