Only Want Cetain Records in a List Box

[Pucklvr001]

Hello,



I am stuck.. I am trying to create a database for my classroom.

I have fields for: StudentsName, RecordingPeriod, Subject, AssessmentName, AssessmentQuestions.

When I create a form.. I want the specific assessment questions from a specific Assessment name to show up in a List box.

I have tried to run a query, but they all still show up...

Can anyone help me achieve this??

THANK YOU!!!

[June7]

Need more info about data structure. What are the tables and how are they related? Is AssessmentQuestions a multi-value field?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Pucklvr001]

Need more info about data structure. What are the tables and how are they related? Is AssessmentQuestions a multi-value field?

If you want to provide db for analysis, follow instructions at bottom of my post.

I have tables for:
Subject
RecordingPeriod
AssessmentName
AssessmentQuestions

The Assessment Questions is a multi-value field yes.

I have to tell you... I am really learning access right now..

Here is what I would like:

I want to track student data from a certain assessment.
So I input:
The subject
Recording Period
The Assessment Given

Then I want to create a form that allows me to enter scores for each assessment question based on the assessment that was given.

Does that make sense? am I at least on the right track??

[June7]

Does not clarify.

You have tables:
Subject
RecordingPeriod
AssessmentName
AssessmentQuestions

Or did you mean fields?

Consider:

tblSubject
SubjectID
SubjectName

tblQuestions
QuestionID
QuestionStatement

tblAssessment
AssessID
Period
SubjectID

tblAssessmentScore
AssessID
QuestionID
Score

What are data relationships? Can same questions relate to multiple subjects? Can there be multiple subjects for each period?

I NEVER use multi-value field.