M
Martin Watts
I've got a database which holds student details which are entered when they
enrol for a course. I need to get statistical data per quarter and have a
query which returns records for enrolments for any selected quarter. I then
have some calculated controls on a report which counts the number of
students, ethnicity, age groups etc.
Trouble is that if a student enrols on say, three courses in the same
quarter the query will then return that students details three times which
are then counted three times in the statistical data returned by the
controls on the report. A find duplicates query is no good as it identifies
the number of duplicate records for each student but will not identify the
other data used in the statistical calculations.
What I need to do is ensure only one record for each student is returned by
the query. The multiple records all contain exactly the same data. How
would the experts do it?
TIA
Martin Watts
enrol for a course. I need to get statistical data per quarter and have a
query which returns records for enrolments for any selected quarter. I then
have some calculated controls on a report which counts the number of
students, ethnicity, age groups etc.
Trouble is that if a student enrols on say, three courses in the same
quarter the query will then return that students details three times which
are then counted three times in the statistical data returned by the
controls on the report. A find duplicates query is no good as it identifies
the number of duplicate records for each student but will not identify the
other data used in the statistical calculations.
What I need to do is ensure only one record for each student is returned by
the query. The multiple records all contain exactly the same data. How
would the experts do it?
TIA
Martin Watts