Jump to content
Sign in to follow this  
susan

Finding Unique Records

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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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