1. Sign-up to become a member, and most of the ads you see will disappear. It only takes 30 seconds to sign up, so join the discussion today!
    Dismiss Notice

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
    Trophy Points:
    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
    Trophy Points:
    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
    Trophy Points:
    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
    Trophy Points:
    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
    Trophy Points:
    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
    Trophy Points:
    0
     
  7. Ted Lee

    Ted Lee Lead Actor

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

Share This Page