How to remove duplicates from linked table query?

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

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: Write data to 2nd table
    ... Yes, Ofer is correct! ... Create a new query based on TblCandidates. ... into the first field of the query design grid. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Write data to 2nd table
    ... > From TableName ... > TableName = The name of the table assuming it tblCandidates ... > DateField = the name of the field that contain the date in table ... I have not created a query which looks like this; ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to remove duplicates from linked table query?
    ... please advise which Industry and which Position ... would you like the Query to return for Candidate 284? ... please describe your criteria to select the above. ... > I run a query on a 'tblCandidates' table linked to two other tables ...
    (microsoft.public.access.queries)
  • RE: Write data to 2nd table
    ... When in the Select Query screen of qCalling I ... > From TableName ... > TableName = The name of the table assuming it tblCandidates ...
    (microsoft.public.access.modulesdaovba)
  • Write data to 2nd table
    ... How can I write the result of dcount using tblCandidates to tblStatistics? ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)