title: extracted data from one column to another i ms access
body: <p>I have a Address field with data(example:24 Gordon Street,Primrose,PRETORIA). Have a query with Like statement: Like "<em>PRETORIA</em>" as criteria in address field in the query to extract all address with PRETORIA in it. I want to know how to place PRETORIA or another city I choose to extract in a column/field called City in the same table or a new table with all the other fields also included in the table.</p>