[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___