Quick way to update records

N

Nikki

I have 2000 records and I need to update 300 of them by simply adding yes to
a field value. I have a list of email addresses for the record in excel. I
tried to do a match query by making another table using the email list from
excel and matching them to my current contact table, but when I do that the
recordset is not updateable. So I have them all there just like I need, but
can't change the field I need to to "yes". What is a better way to go about
this process? Thanks for the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a quick way to create an Update query? 3
Query to select individual records 4
Quick way to put all records in email field of query in Bcc of Outlook 2
Create update query for remaining records 10
update query only works partially 4
Selectively Update Field in Table 2
Matching records for an update query 11
Access Dcount (multiple criteria) 3

Top