Update query problem

[Tony Williams]

I have a field txtdatephotorecd in a table tblindividual. I want to populate
this field with the data that is in a field txtidcardissued in a table
tblidcards The sql for the update query is
UPDATE tblindividual LEFT JOIN tblIDCards ON tblindividual.txtidform =
tblIDCards.txtidform SET tblindividual.txtdatephotorecd =
[tblIDCards].[txtidcardissued];
I get a message that says Xnumber of records are to be updated but they
aren't. What am I doing wrong? The format of both fields is short date.
Thanks
Tony

 

[Tony Williams]

Sorry fixed the problem the join was on the wrong fields OOPs!
Thanks anyway
Tony