Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

Removing duplicates from list

Hi guys,

I'm working in Access and I've got a list that is filled in by the query. How do i remove duplicates from it?
0
Yury Merezhkov
Asked:
Yury Merezhkov
2 Solutions
 
Carl TawnSystems and Integration DeveloperCommented:
You can filter duplicates from the query by using the DISTINCT clause. Post your current SQL and we can try to factor it in for you.
0
 
Yury MerezhkovDevelopment Team LeadAuthor Commented:
Here it is:

SELECT tblClients.ClientCompany, tblCases.CaseDateSched, tblClients.ClientID
FROM tblClients INNER JOIN tblCases ON tblClients.ClientID=tblCases.CaseClientID
WHERE (((tblCases.CaseDateSched)=Forms!frmFullReport!Text37));
0
 
dmitryz6Commented:
both will work
1.
SELECT tblClients.ClientCompany, tblCases.CaseDateSched, tblClients.ClientID
FROM tblClients INNER JOIN tblCases ON tblClients.ClientID=tblCases.CaseClientID
WHERE (((tblCases.CaseDateSched)=Forms!frmFullReport!Text37)) group by tblClients.ClientCompany, tblCases.CaseDateSched, tblClients.ClientID
2.
SELECT Distinct tblClients.ClientCompany, tblCases.CaseDateSched, tblClients.ClientID
FROM tblClients INNER JOIN tblCases ON tblClients.ClientID=tblCases.CaseClientID
WHERE (((tblCases.CaseDateSched)=Forms!frmFullReport!Text37));
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now