Totals Query

[Nile]

Hello everyone! I would really appreciate it if you helped me if you could.

I have this table:
SID PID CLASS
where SID = student id.
where PID = parent id.
CLASS can equal 3, 4, 5, 6 and plus.

Here is an example of the table:
001---23---3 (student 001, parent 23, in class 3)
002---23---5 (another student, same parent 23, in class 5 now)
003---20--12

Now a result of a query:
Parent--Class3or4---Class5---Class6plus
23------1------------1---------0--------
20------0-------------0---------1--------

I hope I made it clear enough, don't wanna puzzle anyone with my
communicational skills .
Thank you in Advance,
Nile (e-mail address removed)

 

[[MVP] S. Clark]

Let's see... a teacher would never use the word, "communicational", so given
that this task is based on student's and classes, that it MUST mean that
this is someone's homework. ;-D.

The only thing you left out of your post, was a question.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-