AND Query...on one field

[Scott]

I need an AND query to search one field. For example, if
I had a field called Courses and wanted to find
individuals that took Intro Access AND Intermediate
Access. In a regular query, this would be an OR query.
I tried adding the field a second time and using the
second parameter...but this did not work. Help!

 

[Cameron Sutherland]

Soudns easy but I feel your pain because its not. Here is
a way around it. You need three queries and hopefully you
have some unique (key) field like StudentID.
query#1 = all students where classes taken = Intro
query#2 = all students where classes taken = Advanced
query#3 = instead of tables drop in the two queries you
made and link them together on your key field. Drop down
the student name and voila.
-Cameron Sutherland

 

[Arvi Laanemets]

Hi

Select Distinct person From YourTable Where person IN (Select person From
YourTable Where course='Intro Access' ) And person IN (Select person From
YourTable Where course='Intermediate Access' )


Arvi Laanemets