Filter on repeated IDs

[Sal2588]

Good day,

I'm creating a db to trace activities done by students where I've created a table with the following columns:
1. StudentID
2. StudentName
3. Birthday
4. Activity
5. ActivityMonth

Then I've Created a form to preview there activities with the same columns

Then I created a textbox where I want to assign a code to filter form as following

I want to write a number for example 3 and I want to filter the form for the students who has participated in 3 or more activities based on their StudentID

so the filter will show all the students who made that number based on their studentID

Many thanks

[isladogs]

As each student can have many activities and each activity could be done by many students, this data needs to be in three separate tables to include these fields:

tblStudents:
StudentID-PK field
LastName
FirstName (as 2 separate fields)
DateOfBirth

tblActivities
ActivityID - PK field
Activity

tblStudentActivities
StudentActivityID - PK field
StudentID - FK field
ActivityID - FK field

The table tblStudentActivities is a junction table linking the other two tables.

Next modify the form record source accordingly with data from each table

The filter can be done in various ways. One is based on an aggregate query where Count(StudentActivityID)>=3

[Sal2588]

Thanks for the reply, the thing here is that the activities assigned won't be repeated so there is no need to assign IDs to it.

However the students id will be repeated
So I need to filter on it only

As I mentioned earlier I want to assign a code to the Txtbox that will show the repeated IDs on the form

Thanks