Re: returning a certain qualification

Do you have a text field something like:- "B Sc, M.Sc, 50 yds Crawl" ?

or individual records:

B Sc
M.Sc
50 yds Crawl

?


"Martin Hopkins" <martin.hoppy@xxxxxxxxxxxx> wrote in message
news:nW61h.19806$j4.5494@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am running a report that lets me know if certain people do not have a
certain qualification.

All works well if the employee has no qualifications and the return is
true.

However if an employee has many qualifications including the qualification
in the search or not, I get them returned in the report output.

The query works from a field value from a report and searches records for
name, dept, <>qualification.

Becuase employee B holds qualification required plus others, he still
appears in thecreport, because, i think, he stills holds other
quailications <>qualification search.

How can I say, return any employee who does not hold the required
qualification and ignore ny others held.

thanks in advance for any help.

Martin Hopkins




.

Relevant Pages

  • Re: Cross ref to a sub-report
    ... You could add a subquery to indicate ... whether the person has the qualification or not. ... EXISTS (SELECT ID FROM PersonQualification ... Format menu in report design view) to color the text boxes. ...
    (microsoft.public.access.reports)
  • Re: How to create different parameters for the same report
    ... you can do this if you leave the criteria out of the query that feeds ... > button to open the report. ... >> member, Report By member by qualification. ...
    (microsoft.public.access.reports)
  • Re: How to create different parameters for the same report
    ... you can do this if you leave the criteria out of the query that feeds ... button to open the report. ... > member, Report By member by qualification. ...
    (microsoft.public.access.reports)
  • Re: returning a certain qualification
    ... qualification. ... All works well if the employee has no qualifications and the return is ... qualification in the search or not, I get them returned in the report ... Becuase employee B holds qualification required plus others, ...
    (microsoft.public.access.queries)
  • Re: returning a certain qualification
    ... qualification. ... However if an employee has many qualifications including the qualification ... I get them returned in the report output. ... Becuase employee B holds qualification required plus others, ...
    (microsoft.public.access.queries)