Art-
SELECT Count(tblStudent.StudentID), tblStudent.GenderID,
tblStudentBarrier.BarrierTypeID
FROM tblStudent INNER JOIN tblStudentBarrier
ON tblStudent.StudentID = tblStudentBarrier.StudentID
GROUP BY tblStudent.GenderID, tblStudentBarrier.BarrierTypeID;
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
Sent: Friday, July 15, 2011 8:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Nested counts
I have been tasked to write a query to break down barriers by gender.
The tables involved are as follows:
tblStudent
StudentID PK
DateOfEntry
GenderID
tblStudentBarrier
BarrierID PK
StudentID
BarrierTypeID
I need to be able to breakdown the number of male students who have encountered
whatever barrier is contained in barrierID and also do this for the females.
Any Ideas,
Art Lorenzini
Sioux Falls, SD
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar