Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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