Update Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using one table in an update query and I want to be able to update items
from one field based on what is found in another field. It seems like it
should be simple, but everything I have tried as "criteria" hasn't worked.
 
Criteria does not update. It selects/filters records.

Post your query SQL by opening the query in design view, click on menu VIEW
- SQL View, highlight all, copy, and paste in a post.
 
Sorry if I wasn't clear, but I actually figured it out myself this morning.
Here is what I ended up with in my query SQL for anyone else who has this
question:

UPDATE CycleFileTable SET CycleFileTable.RemainingLife = "11"
WHERE (((CycleFileTable.LocationID) Like "MH*") AND
((CycleFileTable.SummaryCode)="1016"));

Thanks for the reply, I'll try to be more specific next time.

-KC
 
Back
Top