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,

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


hharriel@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,

Here is the SQL:

UPDATE DISTINCTROW 97106courseIDs2 INNER JOIN dbo_R0004_COUR_COURSE ON
[97106courseIDs2].COUR_NAME = dbo_R0004_COUR_COURSE.COUR_NAME SET
dbo_R0004_COUR_COURSE.COUR_NAME = [97106courseID2].[cour_name],
dbo_R0004_COUR_COURSE.COUR_HRS_NUM = [97106courseID2].[cour_hrs_num]
WHERE (((dbo_R0004_COUR_COURSE.COUR_SCHL_ID)="97106"));

Thanks

Jeff L wrote:

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

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