I have two tables, each with an auto number primary key and a list of words. What do i type in the criteria box of the query in order for the query to compare the two tables and list the words they have in common?? Thanks.
I have two tables, each with an auto number primary key and a list of words. What do i type in the criteria box of the query in order for the query to compare the two tables and list the words they have in common?? Thanks.
No Criteria necessary.
Just join the two tables by the Field that contains the words.
I didn't think of that, I tried it and it worked, thanks!
Or you could join by the Primary Key then in the word field as criteria use the other table's word field.
[OtherTable].[WordField]