SQL Query

P

paulinec

I am trying to run a query that shows employee's who have all qualifications
that are selected on a form.
I can do it where there is a separate table with the qualifications selected
but I would like to be able to use a table I already have which a subform of
another form.
The Fields I have in the query are StudentId and QualificationId (both from
the Student table) and I am using the following SQL in the criteria of the
QualificationId column
(SELECT Count(*) FROM tbEmployerQualRequirements WHERE [eeRequirementId] =
Forms![fmEmployerDetails]![fmEmployerEmploymentRequirements].Form![fmEmployerQualificationRequirements].Form![QualificationId] ;)

Can anyone tell me what is wrong with this, as it is not working.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unmatched Query Help Wanted 2
Number of Students Completing a Qualification for a Date Range 1
Can I save a sql statement generated by a search form? 1
Crating User Form to Add Names 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2010 DB not fuctional with multiple users 2
How to display zero value in blank fields of Cross Tab query 0
QBF & Query Malfunction 0

Top