AND Query...on one field

  • Thread starter Thread starter Scott
  • Start date Start date
S

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!
 
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
 
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
 
Back
Top