Re: How not to display similar records in a subform?

Hi Jeff,

The point of the query is to return candidates who posses the Industry and
of Position Types or any combination of either, so are a necessary criteria.
The user only needs to see that candidate listed once however.

I've tried various combinations of the 'Unique Values' property, DISTINCT
and FIRST and none of them work. Any other ideas?

Regards,

Penny.

"Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eSVAoinIGHA.2708@xxxxxxxxxxxxxxxxxxxxxxx
> Penny
>
> If Industry and Position Type are not germane, why show them? In fact,
> why
> include them in the query? If you want to see unique values of
> CandidateID,
> change that property in your query to show Unique Values.
>
> --
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Penny" <penny@xxxxxxxxxxxxxx> wrote in message
> news:newscache$iq8pti$11g$1@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi All,
>>
>> I run a query based on a dynamically generated SQL select statement that
>> draws from a parent table and two linked tables. I then make the subforms
>> recordsource the query string. It works nicely to return and display the
>> Candidates who match the desired criteria and all the permutations of the
>> criteria combinations they've been matched against(example shown below).
>>
>> CandidateID Name Industry PositionType
>>
>> 543 Mary Health
> Secretary
>> 284 Sarah Aged Care
> Receptionist
>> 284 Sarah Aged Care Payroll
>> 284 Sarah Construction
> Receptionist
>> 284 Sarah Construction
> Administration
>> 889 Bob Banking Payroll
>>
>> But I only need to show each Candidate only once to display to the user,
> the
>> Industry and PositionType combinations are not needed for display
> purposes.
>> Is there any way to get the form to show each candidate id only once? Any
>> tips?
>>
>> Regards,
>>
>> Penny.
>>
>>
>


.

Relevant Pages

  • 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: How to remove duplicates from linked table query?
    ... you can use a query ... I guess I need to enter the Industry and/or ... > against their ID in tblCandidateIndustries and Receptionist against their ... please describe your criteria to select the above. ...
    (microsoft.public.access.queries)
  • RE: Filtering a subform using many combo boxes
    ... SELECT AssignedPriority, AssignedPriorityDetail FROM tblAssignedPriority ... YES for all of the combo boxes.) ... I followed you instructions to the letter and every one of the criteria ... open the query "qryProjects" in design view. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
Quantcast