[help] Query with 1 or n parameter

[maurizio.ferracini]

a student know one ore more programming language

in a mask i select from a list_box one or more language and i send ad
parameter to a query that extract the student that know all this
language.

i use something like

table: Student,Language,Student- Language

query:
....
[Student- Language].Id_Lang
LikeNz([Forms]![Student-Query-param]![Lang_l_box],"*")

but if i select "ADA and C" the query report student that know :C or
ADA or C and ADA.

how i can do for got only the student that know "C *and* ADA"?.

grazie.

[ray]

Hi maurizio,

I think your query will be a bit more complex.

It will have to look something like:

Select StudentID from STUDENTS where
StudentID IN
(Select StudentID from STUDENT-LANGUAGE where LanguageID = "C")
AND
StudentID IN
(Select StudentID from STUDENT-LANGUAGE where LanguageID = "ADA")

Just add each new criteria as you iterate through the listbox.

Ray
ma****************@gmail.com wrote:

a student know one ore more programming language

in a mask i select from a list_box one or more language and i send ad
parameter to a query that extract the student that know all this
language.

i use something like

table: Student,Language,Student- Language

query:
...
[Student- Language].Id_Lang
LikeNz([Forms]![Student-Query-param]![Lang_l_box],"*")

but if i select "ADA and C" the query report student that know :C or
ADA or C and ADA.

how i can do for got only the student that know "C *and* ADA"?.

grazie.