Update Query to mark individuals with bouncing emails

[Erin]

Hi All,
I am working with a database of contacts that has not been updated for a long time. We have ~600 emails that have unsubscribed in our email marketing service provider and ~7000 emails that are bouncing. We now need to update our Access database to reflect this. We have a field for "Status" that contains the options "DoNotEmail" and "obsolete", so I'd like to assign these two groups to their respective categories.

My strategy was to create an update query that would link our main table of data to a table that only contained email addresses and the new status, link the tables on email addresses, and try to get the query to update the status. It is asking me to enter the parameter value, and I think I have. Obviously, I'm doing something wrong, and my examination of microsoft.com is not helping. Can you tell me:

1. Does my query need to have a column for every field in my original table? Or just for the one that I am trying to change? (Actually I've tried it both ways and it doesn't seem to work either way. So maybe this question is irrelevant.)
2. Do I have the "Update to" field right?


Here's the screen shot of what I set up, with the error message that appeared:



Thanks for the help!

[NTC]

No you don't need every field ; in an update query you just need the field(s) that are being updated

The parameter prompt indicates something is not right - right now I would say it is a simple spelling error between your table name in the column vs its strangely spelled name of the table itself.

[Erin]

Thanks very much for the help. I did indeed have a typo in my table name. Our database is also a mess and had a table called "Outreach" and a table called "TableOutreach". (Because that's not confusing at all...)

Happy to report the update now works!