I haven't run this since 2008 or so, and I just updated to Office265 and Access 2013. I can't figure out what the issue is... And I'm very rusty. Can anyone look at what I have and make a suggestion on how to fix it?
Thanks in advance,
Tom
Two tables. Just trying to update the sex in one table with the values from the other, if the name fields match at least the first 8 characters. Simple gender assignment.
TABLE 1
F2013_Batch1
fname
sex
TABLE2
tblCleanupGender
CU1Name
CUsex
This is the SQL Access generates based on the tables.
UPDATE tblCleanupGender, F2013_Batch1 AS F2013_Batch1_1 SET F2013_Batch1_1.sex = [tblCleanupGender].[CUsex]
WHERE (((F2013_Batch1_1.fname)=[tblCleanupGender].[CU1Name]));