HELP with UPDATE Query

[taimysho0]

Hello, i have an update query that looks at a master table and grabs the values in the "last read date" column and updates it to another table (lets call it table 2) with the same column.



If the last readdate is greater than the due date then print a "0", if not, then do the calculation of date()-due date.

This works great, but it updates every row in table 2. I want it so that if the row already contains a "0", then dont update the last read date for that row. How would i get it to do this? thanks

This is my code:

IIf([LastReadDate]>=[due date],"0",Date()-[Due Date])

[orange]

Take a look here
http://www.w3schools.com/sql/sql_update.asp

especially the Warning statement

[taimysho0]

ahh i see, so if i put "not like "0"" in the criteria, it should maintain that logic then correct?

[orange]

Please show the full sql of your query.