is there a query to update a table cell, not add rows

[RKS]

I have two tables. the first one has many fields but
three of them are first name, last name and
contributions. the first and last name is populated in
the table and the contributions is blank. The second
table has three fields....first name, last name, and
contribution. All are populated and the contribution is
populated with YES. This is a subset of the bigger table
ie., those that have contributed Yes. How can I get my
first, big table updated with the YES in contribution
field matching the first and last name? thank you
..

 

[Duane Hookom]

Set FirstName and LastName of your smaller table as a primary key. Then
create a table with both tables and join the name fields. Add the
Big.Contribution and Small.Contribution fields to the grid. View the
datasheet to make sure that all the Small.Contribution fields are YES.
Change the query to an update query and enter "YES" in the Update To: of the
Big.Contribution field. Run the query.