|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 23rd, 2010, 10:34 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Update Query and Too Many Rows
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? 
|
|
#2
February 23rd, 2010, 11:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Update Query and Too Many Rows
On Tue, 23 Feb 2010 14:34:05 -0800, mwilsonh
wrote: 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. -- John W. Vinson [MVP]
|
|
#3
February 23rd, 2010, 11:21 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Update Query and Too Many Rows
Please post the SQL statement for this update query.
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "mwilsonh" wrote: 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?
|
|
#4
February 24th, 2010, 03:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Update Query and Too Many Rows
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" wrote: 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?
|
|
#5
February 24th, 2010, 03:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Update Query and Too Many Rows
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. "mwilsonh" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
