Re: How to remove duplicates from linked table query?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Using your sample data, please advise which Industry and which Position
would you like the Query to return for Candidate 284?

Also, please describe your criteria to select the above.

--
HTH
Van T. Dinh
MVP (Access)



"Penny" <penny@xxxxxxxxxxxxxx> wrote in message
news:newscache$q3e8ti$be2$1@xxxxxxxxxxxxxxxxxxxxxxx
> Hi All,
>
> I run a query on a 'tblCandidates' table linked to two other tables
> 'tblCandidateIndustries' and 'tblCandidatePositions' each of which may
> have many records pertaining to the Candidate in the parent table.
>
> The query returns every permutation of Candidate, Industry and Position in
> a seperate line, e.g.
>
> CandidateID Industry Position
>
> 543 Health Secretary
> 284 Aged Care Admin Assistant
> 284 Aged Care Receptionist
> 284 Construction Book Keeper
> 284 Construction Payroll
> 889 Banking Finance Broker
>
> But I only need to show each Candidate only once to display to the user. I
> haven't been able to get DISTINCT or FIRST to remove the duplicates. Any
> tips?
>
> Regards,
>
> Penny.
>


.

Relevant Pages

  • Re: Count Problem
    ... Try saving this query as, say, qryIntermediary: ... SELECT Industry, Sum(SumOfCosts) As Costs, CountAs NoOfCustomers ... GROUP BY Industry, Customer) AS Subquery ...
    (microsoft.public.access.queries)
  • RE: Query returning many duplicate records
    ... If you wanted to calculate the number of establishments in a particular ... Then, in the query you would add the Industry column, and the ... "Roberto" wrote: ...
    (microsoft.public.access.queries)
  • Re: Query Improvement
    ... INDUSTRY: Index on IND_ID column. ... query you do not use a NVL function for the join. ... Even in older versions it should help to write it as an equijoin without IN or EXISTS and let the CBO decide about the driving table. ...
    (comp.databases.oracle.server)
  • Re: How not to display similar records in a subform?
    ... of Position Types or any combination of either, so are a necessary criteria. ... > If Industry and Position Type are not germane, ... > include them in the query? ...
    (microsoft.public.access.forms)
  • Re: How to remove duplicates from linked table query?
    ... Position as parameters into the query and return all Candidates who have at ... I would need to enter the industry as a parameter into the query. ... >> 'tblCandidateIndustries' and 'tblCandidatePositions' each of which may ... >> Penny. ...
    (microsoft.public.access.queries)