Update Query and Too Many Rows

[mwilsonh]

I have 700 records I want to update. When I view the the data sheet view of
the query, it looks correct, but when I actually run the query, I get a
message that I am about to update 800 rows. Why is it going to update 100
more rows than I specified?

 

[John W. Vinson]

I have 700 records I want to update. When I view the the data sheet view of
the query, it looks correct, but when I actually run the query, I get a
message that I am about to update 800 rows. Why is it going to update 100
more rows than I specified?

No way to tell unless you give us some more information! Please post the SQL
view of the query and some indication about the table structure.

 

[Jerry Whittle]

Please post the SQL statement for this update query.

 

[mwilsonh]

Sorry, I should have included this.

UPDATE DISTINCTROW Courses INNER JOIN [Courses by Instructor Summer 2010] ON
Courses.CRN = [Courses by Instructor Summer 2010].CRN SET Courses.[G Number]
= [Courses by Instructor Summer 2010]![G Number], Courses.School = [Courses
by Instructor Summer 2010]![School], Courses.[Primary Ind] = [Courses by
Instructor Summer 2010]![Primary Ind], Courses.CRN = [Courses by Instructor
Summer 2010]![CRN], Courses.Course = [Courses by Instructor Summer
2010]![Course], Courses.[Section] = [Courses by Instructor Summer
2010]![Section], Courses.[Section Title] = [Courses by Instructor Summer
2010]![Section Title], Courses.[Min Cr Hrs] = [Courses by Instructor Summer
2010]![Min Cr Hrs], Courses.Enrolled = [Courses by Instructor Summer
2010]![Enrolled], Courses.Status = [Courses by Instructor Summer
2010]![Status], Courses.[Xlst Group] = [Courses by Instructor Summer
2010]![Xlst Group]
WHERE (((Courses.Semester)="S10"));

Thank you so much for helping me with this! I can't find documentation for
this anywhere...

 

[mwilsonh]

I think I've solved this. I joined the G Number fields and joined the CRN
fields and this limited it to the correct number of records.