Jump to content

Finding Unique Records


susan

This topic is 8185 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a Tests file with 5000+ records. Many of the records have the same student_id (each record is an instance in which a student takes one of 16 different tests during a school year. Students take the same tests each year--if they stay in the same school they will have 96 records)

I want to be able to find 1 occurance of each student. It doesn't matter which test/record is found. I just need to be able to tell how many different students are entered, and see their names and grad year.

Thanks.

Susan

Link to comment
Share on other sites

If all you want is a list of different Student IDs then all you have to do is create a value-list based on the values in the field 'Student ID'

For showing the rest of the information based on the ID, you can either run a find using the value list (which will find all of the records), or you can create a self-relationship (assuming there is only one database) based on the field 'Student ID'. On the same layout you can put a portal (defined by this relationship) with only one row that will show only the first record from the current 'Student ID'

Hope this helps

Link to comment
Share on other sites

This topic is 8185 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.