Move Data with query

  • Thread starter Thread starter bscholl
  • Start date Start date
B

bscholl

How can I move specific data from one column to another?
Example: the NAME column of my database has many
different subjects of information, phone number, location,
and name. I want to search this column for specific data
such as "HEALTH" or "POLICE" and then move that data to
another column. If I have a template that I can modify, I
could change the specific data to what I need to move.

(e-mail address removed)
 
You can't move data, but you can copy data. An Update query would do what
you want. In the query builder select your table. Then specify that this
is an update query. Include in the query the field (column) you are
seaching (I'll call this Field1) and the field you want it put into
(Field2). In the Update To row for Field1 write [Field1], then in the
criteria row for Field1 put in your search list. Include the entire line at
once with "" around each word.

"Health" or "Police" or etc..

Run the query and your data should be moved. If you want to move to
different fields and not just one, repeat the procedure using the other
fields and only the criteria that applies to that situation.

Kelvin
 
Back
Top