+ Reply to Thread
Results 1 to 2 of 2

Query - Single records

  1. #1
    Registered User
    Join Date
    03-13-2023
    Location
    Luxembourg
    MS-Off Ver
    365
    Posts
    25

    Query - Single records

    Hi everyone

    I have created the database attached. I need a query that somehow matches a row from the original table with a row from the new table. The query I want should get from both tables those that

    1) Have the exact same Code1 and Code2,
    2) Have a different CName,
    3) Have the same Test.

    It works fine except for one thing: The query is creating combinations. I would like the query to look like the "WantedResult" table

    Could you please help me?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    1,817

    Re: Query - Single records

    Try to write a ugly sql.

    Please Login or Register  to view this content.
    Last edited by windknife; 12-29-2023 at 02:45 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. New Records in Query
    By jarett in forum Access Tables & Databases
    Replies: 3
    Last Post: 04-16-2021, 10:45 AM
  2. Replies: 8
    Last Post: 10-21-2020, 03:02 AM
  3. Retrieve single records and no call duration records
    By santbiju in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2017, 08:41 AM
  4. Count single records when duplicate records exist
    By omeng414 in forum Excel General
    Replies: 4
    Last Post: 11-27-2014, 03:42 PM
  5. [SOLVED] VBA to rearrange 11000 records into 550 rows (20 records combined into a single row)
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-27-2014, 11:56 PM
  6. Query - Multiple Records?
    By TehNoob2010 in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-30-2012, 06:50 AM
  7. Query Records
    By madcat302 in forum Excel General
    Replies: 0
    Last Post: 05-08-2010, 06:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1