Results 1 to 2 of 2
  1. #1
    fauowls is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2013
    Posts
    5

    Don't display data with equal value from two tables


    I have a query that pulls data from 2 different tables. The query should display two columns made up from data of the two tables. Some of the data in the two tables are equal. How can avoid from displaying equal results.

    Dog Cat
    Dog Dog
    Elephant Cow
    Cow Chicken
    Dog Chicken

    I do not want to display the result in row 2 seeing that both are equal.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Can you show us the SQL of the query that gives the results shown in your post.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 3
    Last Post: 02-03-2013, 08:47 PM
  2. Display/print Report with two tables
    By geraldk in forum Reports
    Replies: 5
    Last Post: 07-30-2012, 02:41 PM
  3. Linked tables need values that are NOT EQUAL
    By gus1339 in forum Queries
    Replies: 3
    Last Post: 04-11-2011, 06:55 PM
  4. How to Display multiple tables in one form
    By saruafra in forum Access
    Replies: 4
    Last Post: 03-06-2011, 07:23 PM
  5. Query to Display Tables & Fields
    By foxerator in forum Queries
    Replies: 0
    Last Post: 04-24-2008, 09:57 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