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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Table Query Is Blank 1
sub query refrence field in main query 1
Help! Need to update linked SQL table in Acc07 3
Query with common fields to all records 6
Finding wrong values for keyfield 2
update file for current record only 2
query to find difference in record sets 2
SELECT Statement Question 5

Back
Top