Results 1 to 4 of 4
  1. #1
    masterofwee is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    2

    query to identify two identical text fields in two different tables

    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.

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    No Criteria necessary.

    Just join the two tables by the Field that contains the words.

  3. #3
    masterofwee is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    2
    I didn't think of that, I tried it and it worked, thanks!

  4. #4
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Or you could join by the Primary Key then in the word field as criteria use the other table's word field.

    [OtherTable].[WordField]

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Difference between 2 identical tables.
    By leepan2008 in forum Access
    Replies: 1
    Last Post: 09-28-2009, 07:36 PM
  2. Replies: 1
    Last Post: 03-31-2009, 09:03 AM
  3. Query to Display Tables & Fields
    By foxerator in forum Queries
    Replies: 0
    Last Post: 04-24-2008, 09:57 AM
  4. Validation on identical text question
    By edrahl in forum Database Design
    Replies: 1
    Last Post: 02-26-2008, 09:38 AM
  5. One table multiple fields identical properties.
    By swampdonkey in forum Queries
    Replies: 2
    Last Post: 09-29-2006, 10:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums