Updating a table's yes/no field based on another table

[max117]

Hi,

I'm new to Access so the question below might be better stated:

I'm trying to update the yes/no field from one table containing a list of members based on whether their last name appears on another table. If their name is in the other table then I want the cell corresponding to them to be checked and if not unchecked.

Is this possible?

 

[Ranman256]

Yes, make an update query,
Join the 2 tables on the like field, set any criteria,
Set field= true

 

[max117]

Ranman256 and Pat,

Your advice worked perfectly! Thank you for all the help.

Max