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"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Access Dcount (multiple criteria) 3
Using "Count" in Queries 1
All-Record criteria in a query...hmmm 4
Update Query (multiple fields) 11
Limit the results from a calculated field in a query 7
Update date field to Is Null in an update query 3
query relelated to 2 combo boxes 2

Back
Top