Update Query

  • Thread starter Thread starter Ron
  • Start date Start date
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.
 
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"?
 
Back
Top