Totals Query


N

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)
 
Ad

Advertisements

M

[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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

totals query 1
Totals Query 10
Totals Query 2
Totals Query 3
Query Totals 3
Query Totals 1
Query for totals 9
Totals Query 2

Top