Update Queries

[MartinO]

I'm trying to update one table with three fields from another(MTI Number, Error Code, Site). Both tables have the same field names and the common link between tables is via a field called MCR I've put them both in a query - converted to an update query and set the update field on the query to [Tablename].[MTI Number] etc etc
I get a message that tells me that i am about to update x rows of data but nothing happens - any ideas?

 

[KevinM]

Does Access report that x num of records could not be updated?

Also check validation in the said fields in design view of the dest. table. Mybe something there is preventing them form being updated

 

[MartinO]

All OK now - had already checked table fields for input mask etc. problem was me! I got confused with the 'Update to' line in the query. Thanks for replying though - Martino