Help with MS Access query...

Discussion in 'Archived Threads 2001-2004' started by Ted Lee, Dec 4, 2002.

  1. Ted Lee

    Ted Lee Lead Actor

    Joined:
    May 8, 2001
    Messages:
    8,390
    Likes Received:
    0
    hi all -

    what i'm trying to do is find duplicate logins from two separate tables.

    i've already designed the query and linked the tables, but i can't remember how to tell access to search for dups.

    any ideas?

    thx,

    ted
     
  2. Kolya

    Kolya Stunt Coordinator

    Joined:
    Mar 10, 2001
    Messages:
    91
    Likes Received:
    0
    something like "select count(*) as total from table1 group by column1 having count(*) > 1" would show you duplicates
     
  3. Ted Lee

    Ted Lee Lead Actor

    Joined:
    May 8, 2001
    Messages:
    8,390
    Likes Received:
    0
    thanks kolya - i may mess around with that.
    however, i'm a dumbass.
    all i had to do was link the two fields. then double-click that "link line" (or whatever it's called) and specify to only show items that match.
    ugh! [​IMG]
     
  4. Kolya

    Kolya Stunt Coordinator

    Joined:
    Mar 10, 2001
    Messages:
    91
    Likes Received:
    0
    [​IMG] No problem
    You were telling Access to perform an "inner join"
     
  5. Ted Lee

    Ted Lee Lead Actor

    Joined:
    May 8, 2001
    Messages:
    8,390
    Likes Received:
    0
    "inner join"....man i should at least buy access dinner first. [​IMG] [​IMG]
     
  6. Kolya

    Kolya Stunt Coordinator

    Joined:
    Mar 10, 2001
    Messages:
    91
    Likes Received:
    0
     
  7. Ted Lee

    Ted Lee Lead Actor

    Joined:
    May 8, 2001
    Messages:
    8,390
    Likes Received:
    0
    [​IMG]
     

Share This Page