SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2000
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Simple Access Question

    This should be real easy to do, Why can't I figure it out???

    I have a querey that gets information from a few tables. As a result, some information in the table is duplicated.

    How do I eliminate the duplicates?

    I tried making a blank table where one field is indexed (No duplicates) but that elinates some records entirely (haven't figured out why).

    Any help?

    Thanks

  2. #2
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Show us your query, it might help to find a solution.

  3. #3
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try "SELECT DISTINCT ... " instead of just "SELECT ... "

    (or however its done in access... i think there's a "properties" dialog in the query designer that has a distinct checkbox.

  4. #4
    SitePoint Enthusiast
    Join Date
    Dec 2000
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am looking for distinct keycontact_legislator.[Contact Name]

    Here's the SQL:

    SELECT Committees.CommitteeName, Committee_Contact.Legislator, keycontact_legislator.[Contact Name], [KEY CONTACTS].[Firm/Company], [KEY CONTACTS].Email, [KEY CONTACTS].Fax, [KEY CONTACTS].Phone INTO [CS Committee Querey Q1 yes]
    FROM Committees INNER JOIN ([KEY CONTACTS] INNER JOIN (keycontact_legislator INNER JOIN Committee_Contact ON keycontact_legislator.Legislator = Committee_Contact.Legislator) ON [KEY CONTACTS].[Contact Name] = keycontact_legislator.[Contact Name]) ON Committees.CommitteeName = Committee_Contact.Committee
    WHERE (((Committees.subject1)=Yes));


    ----------------------
    I didn't see the option under properties...

    Thanks


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
  •