Update Query won't update my values

[hharriel]

Hi All,

I have created an update query related to high school course
information (name of course; credit hour; course description, etc.) I
am updating a master course information table. I am updating two fields
in the master table; course name and credit hour. When I run a test,
the course name updates fine. However, I have three different values
that can be in the credit hour files: .05, 1, and 2 (also there are
some records that don't have the credit hour information). The
majority of the credit hour field does not update. Some of the .05s
and the 1 values update, but very few (something like 20 out of 275
records). When running the test update, in the credit hour field, it
mostly puts zeros.

I have checked to make sure that the field criteria for the table I am
updating from and the table I am updating to (the master course table)
are the same; "number".

Any help you all could provide would help a whole lot,
Thanks,

[Jeff L]

It would probably help if you could post your query you are running.
hh******@gmail. com wrote:

Hi All,

I have created an update query related to high school course
information (name of course; credit hour; course description, etc.) I
am updating a master course information table. I am updating two fields
in the master table; course name and credit hour. When I run a test,
the course name updates fine. However, I have three different values
that can be in the credit hour files: .05, 1, and 2 (also there are
some records that don't have the credit hour information). The
majority of the credit hour field does not update. Some of the .05s
and the 1 values update, but very few (something like 20 out of 275
records). When running the test update, in the credit hour field, it
mostly puts zeros.

I have checked to make sure that the field criteria for the table I am
updating from and the table I am updating to (the master course table)
are the same; "number".

Any help you all could provide would help a whole lot,
Thanks,

[hharriel]

Here is the SQL:

UPDATE DISTINCTROW 97106courseIDs2 INNER JOIN dbo_R0004_COUR_ COURSE ON
[97106courseIDs2].COUR_NAME = dbo_R0004_COUR_ COURSE.COUR_NAM E SET
dbo_R0004_COUR_ COURSE.COUR_NAM E = [97106courseID2].[cour_name],
dbo_R0004_COUR_ COURSE.COUR_HRS _NUM = [97106courseID2].[cour_hrs_num]
WHERE (((dbo_R0004_CO UR_COURSE.COUR_ SCHL_ID)="97106 "));

Thanks

Jeff L wrote:

It would probably help if you could post your query you are running.

[pietlinden]

remove the DISTINCTROW keyword... the rest looks fine.