update query code problem

[Jen0dorf]

Hi



got myself in a bit of a mess - I have two table

table 1 (tblDeceased)contains:

GraveID, Mlink,Plot,GraveNo,Map,Forenames,Surname,Age,DayOf Death,MonthOfDeath,YearOfDeath,DayofBurial,MonthOf Burial,YearOfBurial,Inscription,PP,Notes,Notes_2

The second table (tblGraves_2015) contains the exact fields

I want to update ([tblDeceased]![Notes_2] with the values from [tblGraves_2015]![Notes_2015]

I assumed this would use an update query

So I wanted the update query criteria to be update providing the fields Plot,GraveNo,Forenames and Surname were the same in both tables.

So ( Having learnt wizards are a double edged sword) I selected Query Design and double clicked on tblDeceased and tblGraves_2015.

I then dragged the mouse from Mlink to Mlink to create a "relationship"

I then pressed the Update button.

In the box I selected : field to be Notes_2 and the table to be tblDeceased

I then selected the Update To: option and started to type tbl... expecting in the drop down box to see tblGraves_2015

But it does not appear in the list.

So my sql is as below

UPDATE Graves_2015 INNER JOIN tblDeceased ON Graves_2015.MLink = tblDeceased.Mlink SET tblDeceased.notes_2 = ;

Is my method wrong or have I missed a step

thanks

Ian

[ranman256]

You shouldnt make table names with dates on them. tblGraves is sufficient.

Yes, you use update queries, but Access cannot update MEMO fields, so I hope your NOTES field is NOT that.

[Jen0dorf]

Hi

dammed Memo fields!!!!

thanks

Ian