Dcount question

[Evi]

If I understand you correctly, you will probably have
a table which contains a list of all the subjects avalable
an Exam table linked to the the Subjects table which gives the Exam details
(eg date of exam), the maximum score (MaxScore) in points (and possibly the
score of a 'Fail' grade)
a table of students,
a StudentsInExams table containing a link to the students table, a link to
the exam table and the score which that student got in that exam
(StudentScore).
If this is true, then a field (lets call it PcntScore which says
StudentScore/MaxScore and formatted as a percentage will tell you what the
percentage score is. The Filter Criteria under this PcntScore field for
under 70% is
<70/100

Evi

 

[derek]

If I understand you correctly, you will probably have
a table which contains a list of all the subjects avalable
an Exam table linked to the the Subjects table which gives the Exam details
(eg date of exam), the maximum score (MaxScore) in points (and possibly the
score of a 'Fail' grade)
a table of students,
a StudentsInExams table containing a link to the students table, a link to
the exam table and the score which that student got in that exam
(StudentScore).
If this is true, then a field (lets call it PcntScore which says
StudentScore/MaxScore and formatted as a percentage will tell you what the
percentage score is. The Filter Criteria under this PcntScore field for
under 70% is
<70/100

Evi

I know how to do the Dcount below. My question is how to do
two queries with it?

I need to pull in a student ID and a range of Scores.
I tried many combinations and can't get it right.

the other Field is named Scores in tblScoresReport
I would like to have all that is less than 70 percent.

=Dcount("*", "tblScoresReport","[StudentID] ='IdNumber")

in this case create a secondary query based on the two table the do
you dcount on the query.

 

[jay]

I know how to do the Dcount below. My question is how to do
two queries with it?

I need to pull in a student ID and a range of Scores.
I tried many combinations and can't get it right.

the other Field is named Scores in tblScoresReport
I would like to have all that is less than 70 percent.


=Dcount("*", "tblScoresReport","[StudentID] ='IdNumber")

 

[jay]

If I understand you correctly, you will probably have
a table which contains a list of all the subjects avalable
an Exam table linked to the the Subjects table which gives the Exam
details (eg date of exam), the maximum score (MaxScore) in points (and
possibly the score of a 'Fail' grade)
a table of students,
a StudentsInExams table containing a link to the students table, a link
to the exam table and the score which that student got in that exam
(StudentScore).
If this is true, then a field (lets call it PcntScore which says
StudentScore/MaxScore and formatted as a percentage will tell you what
the percentage score is. The Filter Criteria under this PcntScore field
for under 70% is
<70/100

Evi

I know how to do the Dcount below. My question is how to do
two queries with it?

I need to pull in a student ID and a range of Scores.
I tried many combinations and can't get it right.

the other Field is named Scores in tblScoresReport
I would like to have all that is less than 70 percent.

=Dcount("*", "tblScoresReport","[StudentID] ='IdNumber")

in this case create a secondary query based on the two table the do
you dcount on the query.

I got my solution.
=Dcount("*", "tblScoresReport","[StudentID] ='IdNumber' And [StudentScore] <
70")