Results 1 to 2 of 2
  1. #1
    nussemj is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    1

    Question Query or Report only two fields to generate 2 resultant lists


    Hi, I am a relatively new user of Access and this forum. My objective is fairly simple in that I wish to compare two lists of words (Text) and generate two possible outcome. If field one is WORD and contains say 100 words and Field Two is a smaller list of say 50 words in which 45 of the 50 are in field one and 5 words are not. I would like to see the 65 words remaining in list one and the 5 new words not in list one going to Field 3 which is empty at the beginning. Attempted to attach excel file, attached .pdf in place. Looking forward to any help of suggestions, thank you for taking the time to read.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Actually not so simple. This will require more than one sql. Consider:

    SELECT Table1.Field1
    FROM Table1 AS Table1_1 RIGHT JOIN Table1 ON Table1_1.Field2 = Table1.Field1
    WHERE (((Table1_1.Field2) Is Null));


    SELECT Table1_1.Field2
    FROM Table1 AS Table1_1 LEFT JOIN Table1 ON Table1_1.Field2 = Table1.Field1
    WHERE (((Table1.Field1) Is Null));
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 04-24-2013, 02:41 PM
  2. Generate report, using check boxes or query
    By rumenrs in forum Reports
    Replies: 15
    Last Post: 04-10-2013, 01:46 PM
  3. Replies: 3
    Last Post: 01-18-2013, 11:44 AM
  4. Replies: 2
    Last Post: 06-10-2012, 01:10 PM
  5. Query Won't Generate Report
    By italianfinancier in forum Queries
    Replies: 1
    Last Post: 06-02-2011, 03:48 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