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).
Show us your query, it might help to find a solution.
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.
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
I didn't see the option under properties...