Results 1 to 2 of 2
  1. #1
    JeffGeorge is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    111

    Combining 2 Query Results

    I have 2 tables with similar structures. Table1 has fields NAME, ROLE, and STATUS and Table2 has fields GROUP, ROLE and STATUS. The ROLE values for Table1 are from values of GROUP in Table2. I want one query that gives me the combined records where STATUS = "ENABLED". If I do individual table queries, Table1 has 7836 records where STATUS = "ENABLED" and Table2 has 48 records where STATUS = "ENABLED". I would like to see all 7884 of these records in one query result. I created an INNER JOIN Table2 ON Table1.ROLE = Table2.GROUP WHERE Table1.STATUS = "ENABLED" OR Table2.STATUS = "ENABLED" but that only gave me 7849 records. What's the simplest way to get the correct number of records?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

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

Similar Threads

  1. Replies: 2
    Last Post: 06-21-2014, 07:11 AM
  2. Combining results of table
    By jenyfer49507 in forum Access
    Replies: 2
    Last Post: 06-12-2012, 05:23 AM
  3. Combining Results of Cross Tab Queries
    By kkyork in forum Queries
    Replies: 4
    Last Post: 06-06-2012, 09:10 AM
  4. Combining results from unrelated tables
    By jwreding in forum Queries
    Replies: 7
    Last Post: 08-12-2011, 01:19 PM
  5. Combining results
    By LANCE in forum Queries
    Replies: 0
    Last Post: 06-11-2009, 07:38 PM

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