uodate query

[Jen0dorf]

Hi

just want to clarify my method if I may

I have two tables one has 39203 records the other 38754 records

I want to update one field from the the smaller table to the larger

where the following fields are equal:

mlink.plot,graveno,forname,surname

I tried to create an update query but the wizard only seems to allow for one matching criteria

I created this code but it does not appear to work



UPDATE tblDeceased SET tblDeceased.Notes = [tblGraves]![Notes]
WHERE (((tblDeceased.Mlink)=[tblGraves]![MLink]) AND ((tblDeceased.Plot)=[tblGraves]![Plot]) AND ((tblDeceased.GraveNo)=[tblGraves]![GraveNo]) AND ((tblDeceased.Forenames)=[tblGraves]![Forenames]) AND ((tblDeceased.Surname)=[tblGraves]![Surname]));[/CODE]


it asks for a perameter tblGraves!Notes

Is my method wrong?

thanks

Ian

[ranman256]

Sometimes that many joins won't work like you think.
Start removing joins and run (but don't confirm yes to the update)
this will show where the problem is.

[JoeM]

Usually, if you want to update one table from another, you use a JOIN in there somewhere.
See: http://www.techonthenet.com/sql/update.php