Update Select Operation Must Use an Updateable Query

[aball65]

Can someone please help with the following query/error:

update EXCEL_IEMATRIX_NULLS set EXCEL_IEMATRIX_NULLS.pyld_id = (select PYLD.pyld_id from PYLD inner join EXCEL_IEMATRIX_NULLS on PYLD.pyld=EXCEL_IEMATRIX_NULLS.pyld);

Operation must use an updateable query.

Thanks

 

[vbaInet]

One or both your queries fall into one or more of the categories listed in the link:

http://allenbrowne.com/ser-61.html

 

[aball65]

I'm an Access newbie. Can I get a little more help on a fix to my problem?

 

[aball65]

The following worked for me:

update (select * from EXCEL_IEMATRIX_NULLS inner join PYLD on EXCEL_IEMATRIX_NULLS.pyld = PYLD.pyld) set EXCEL_IEMATRIX_NULLS.pyld_id = PYLD.pyld_id;

 

[vbaInet]

Good job aball65!