By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Checking matching records

P: n/a
I have two tables "Data" and "Check"

Here is the content of the tables:

"Data" "Check"

Field1 Field1 Field2
Jack Jill Yes
Jill Maxi Yes
Dino John Yes
Tomy Rani No
Maxi Tony Yes
Jane Romy No
John Jane Yes
Gems
Rick
Pony
Dick
Tony

I want the Yes/No to be populated automatically. What SQL statement/VBA
code can I write to check if the name in field1 of the "Check" table
appears in field1 of "Data" table and accordingly put Yes/No in field2
of the "Check"table.

The records are not sorted and not in alphabetical order. Even if a
name appear more than once and not in sequence, just put YES

Maxi

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
join the two tables in a query on Field1. include the yes/no field you
want to update. Run to make sure you get the right data. Then turn it
into an update query and set the yes/no field to yes.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.