I'm trying to construct an update query that updates a mailing list table. We have a list of users that have requested not to receive notices and I have a field that I flag if they are NOT on that list. I've previously been using a very long query to exclude these users (
Code:
USERNAME<>"USER1" AND USERNAME<>"USER2"
and so on) but I would prefer to store them in a table a simply use the exclude the values from the table when I run the update query. Unfortunately, I can't do a
Code:
USERNAME<>EXCLUDE.EXCLUDENAMES
. Any sugestions would be appreciated. Thanks!