Update Statment Error Not the proper result

[KWHAT]

i have a uniqueZip table which has a set of unique rows with a certain code, now my goal is to update the Route tbl to have the match code by comparing the rows from one table to the other.

This is my sql statement however this does not change any rows even though there is matching data. Can anyone help me. i attached a image of the tables and fields.


UPDATE [Route tbl], UniqueZips
SET [Route tbl].CODE = [UniqueZips]!

WHERE ((([Route tbl].CODE)=(StrComp([Route tbl]![WINDOW 1]  ,[UniqueZips]![WINDOW 1]) & StrComp([Route tbl]![WINDOW 2]  ,[UniqueZips]![WINDOW 2]) & StrComp([Route tbl]![WINDOW 3]  ,[UniqueZips]![WINDOW 3]) & StrComp([Route tbl]![WINDOW 4]  ,[UniqueZips]![WINDOW 4]) & StrComp([Route tbl]![WINDOW 5]  ,[UniqueZips]![WINDOW 5]))));

 

[vbaInet]

You seriously need to normalize. Window1 to 5 indicates that it's not a normalized structure.

Here are some pretty good links:

http://support.microsoft.com/kb/283878
http://r937.com/relational.html
http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

With regards your OP, if you run the UPDATE query as a SELECT query and it doesn't produce any results, then your criteria is wrongly formed.

 

[KWHAT]

Your right my criteria is wrong i am not producing any results from it, how can i fix this ?

 

[vbaInet]

There's not much I can do to help, but like I said your table design is flawed so if you can fix that the UPDATE statement will be much easier to perform.