423,516 Members | 2,039 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,516 IT Pros & Developers. It's quick & easy.

Update Query won't update my values

P: n/a
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,

Aug 9 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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,
Aug 9 '06 #2

P: n/a
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.
Aug 9 '06 #3

P: n/a
remove the DISTINCTROW keyword... the rest looks fine.

Aug 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.