Returning a value that has the smallest number of instances in a table

Hi

Please help! I'm really stuck. I have a table (AssessorAllocations) that stores the data of students who have submitted assessments for marking by an Assessor. Each time an assessment is submitted by a student my program must determine which Assessor has the smallest workload and then assign the current assessment to that Assessor. My problem is how do I determine which Assessor has the smallest number of assessments assigned to him/her.

The table columns are:

AssessorRegistrationNo

LearnerRegistrationNo

QualficationName

SubjectName

AssessmentName

DateAssigned

Marked

DateMarked

Price

So I'm looking for something like this:

Select AssessorRegistrationNo from AssessorAllocations where {Select the Assessor who has the smallest number of AssessmentNames assigned to him/her where Marked='0' and DateAssigned<>''}

Thanks

Neil

Something like this may work:

HTH!

Above should not sort DESC but just normally.

Else you get the one with the highest workload.

Fantastic! Thank you so much to those who have helped me!

Neil

Johannesburg