Updating records based on another table

[bondalisha]

I'm still learning Access and this is probably very basic.... but here's the situation:

Table1 lists 6,000 organizations [OrgName], their state [State], and their contact information [Phone][Email], plus a yes/no field [Selected]. I need to update the yes/no field of 1,200 specific records to True.

I have a second table [Table2] that lists the 1,200 specific organizations [OrgName]. Table2 has no other fields.

Can I update the records in Table1 that match the [OrgName] listed in Table2?

[RuralGuy]

If you create a query that uses an inner join of Table1 and Table2 then only those records that match will be included.

[Perceptus]

So like this? Entirely untested.
Update table1 inner join table2 on table1.orgname = table2.orgname set table1.selected = true