grouping

D

denise

** 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
 
P

P@tty Ayers

It's pretty much impossible to answer a question with that little
information - sorry.
 
D

denise

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
________________________________________
 
J

Jens Peter Karlsen [FP-MVP]

Sure, use a WHERE clause. Something like:
WHERE product = 110 OR product = 120 OR product = 130.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
Top