Update Query

R

Ron

Using Access 2000, I run an update query using an interger
as my criteria and everything works. I change the criteria
and run it again, nothing works.

Example: Criteria = 2 and change it to 3, it works.
Criteria = 3 returns "You are about to update zero(0)
rows". Looking in the linked table, there are rows with
the field value of 3.
 
J

John Vinson

Using Access 2000, I run an update query using an interger
as my criteria and everything works. I change the criteria
and run it again, nothing works.

Example: Criteria = 2 and change it to 3, it works.
Criteria = 3 returns "You are about to update zero(0)
rows". Looking in the linked table, there are rows with
the field value of 3.
Click to expand...

Please post the SQL view of the query, and doublecheck the datatype of
the field being searched. Might it be a Text field which contains the
text string "3"?
 
Top