Query not returning records

[Daryl2106]

Hi Everyone,



I'm only starting to delevelop a working knowledge of P/F keys and relationships. I am trying to fix some data problems I have in my tables through what I thought would be simple queries. I need to update the AnnualClassNumberID (StudentEnrollment T) from the AnnualClassNumbers Table. (Currently I have a CourseNumber from CourseInventory T in there). I only need to do this for students enrolled in term 1129 (the same student found in Term1129Students T).

I've tried many queries (Query1) with no luck. Strangely there are times when I only get the enrollment records for 2 of the 83 students enrolled in term 1129.

This probalby makes no sense, so please ask if you need clarification.

Thanks and take care,

Daryl

[June7]

Query1 is just a SELECT query and doesn't include all the tables you describe.

You want to update StudentEnrollment table with ClassNumber value from AnnualClassNumbers table?

Add a field in StudentEnrollement table for the ClassNumber.

UPDATE AnnualClassNumbers RIGHT JOIN StudentEnrollmentTable ON AnnualClassNumbers.ID = StudentEnrollmentTable.AnnualClassNumberID SET StudentEnrollmentTable.ClassNumber = [AnnualClassNumbers]![ClassNumber];

However, don't understand how term code 1129 is considered. AnnualClassNumbers table does not include 1129. The only term numbers are 1 and 2. 1129 is not even in the CourseInventory table.

Table relationships don't make sense to me.

[Daryl2106]

Thanks for the reply. From your comments on the use of the term code 1129, I was able to identify a better design for the table data and create the UD_Q as you suggested. Thanks so much!