Unique Records

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

I have a table with numerous records per student, and I
need my query to pull the ethnicity of each student, from
only one record. Within the query I am pulling from many
fields, but I only want it to pull from one student id
record. I do not know how to get the query to look at
unique records for student id.

Thanks for any help you can give.
 
Kim,
Is your query just using 1 table, the 1 with numerous
records per student or many tables? Is ethnicity on every
record for a student, or only on 1?
 
Back
Top