I am looking to update a table with raw data (Highest Completed Module) that will be updated every few months, to update the module status of users in the main table (Master List) of the database.
I am looking to update:
Master List.Last_Completed_Module with Highest Complete Module.Title
Master List.Last_Completed_Module_Date with Highest Complete Module.Last Studied
The field 'Email' is the unique identifier on both tables.
I've been trying to write it in SQL but there's been a syntax error, and when I write it in design view it doesn't populate properly.
In design view, when I run the update, it populates the Master List.Email with about 15 records of each person's email address from Highest Completed.Module, and does the same with Master List.Last_Completed_Module/_Date. Or it just doesn't populate at all.
I wrote a query in design view last week with the same information and it worked fine as a test. Then I uploaded a more complete master list and the same raw data, but with different titles. I'm not quite sure what has gone wrong, I'm still learning about Access!
If anyone could help me I would appreciate it so much, thank you!