Table to table Access update query

February 8, 2011 at 07:43:48
Specs: Windows XP

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!

See More: Table to table Access update query

Report •

February 8, 2011 at 14:02:53
I hit an issue when I had null or blank fields.

I only briefly read your post, so forgive if this was considered. :)

I'm learning.

Report •
Related Solutions

Ask Question