grouping

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

** I want to be able to pull up the names who have the 110,120,and 130
product. Is this possible?
Example:

name product
doe, Jane 110
120
130

doe, john 110

doe, sara 110
120
130
 
It's pretty much impossible to answer a question with that little
information - sorry.
 
I hope this information provides more detail to what I need help with. I
have a database with over a thousand students who have taken several classes.
I need to find a way to pull up students who have taken class a, class b,
and class c only. I don't want the students who have only taken class a.
Does this help?

example:

NAME CLASS
_________________________________________

JOHN DOE ENGLISH 110
MATH 080
HISTORY 200
________________________________________

JANE DOE ENGLISH 110
____________________________________
JOHN SMITH MATH 080
________________________________________
JANE DOE ENGILISH 110
MATH 080
HISTORY 200
________________________________________
 
Sure, use a WHERE clause. Something like:
WHERE product = 110 OR product = 120 OR product = 130.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
Back
Top