Update Query Help

  • Thread starter Thread starter Clay
  • Start date Start date
C

Clay

I have a table called tblOffender. Data is deleted and
re-imported to this table frequently. One of the fields
is called CrimeType. The CrimeType field contains either
Violent, Drug, Sex, Other, or Property.

Recently, we have decided to "re-classify". I need to
create an Update Query that will look in the CrimeType
field and find all of the data that is "Sex" and change
the data from Sex to "Violent".

How can I do this?
 
ok create a query using this table and in design view you
want to hit the query type button on the toolbar at the
top, choose update query then in the field at the bottom
there will be a field called update to and put in there
Violent and where it says criteria put in sex hit
the ! button at the top and bingo it will change
everything.
 
Back
Top