Update

  • Thread starter Thread starter Stewart Walker
  • Start date Start date
S

Stewart Walker

I was wondering if it is possible to create a query which
will remove all spaces within a post code (zip code)

e.g. B67 8QT - I want to become B678QT

I've got over a million records and doing find replace on
the table would take ages!!

TIA

Stewart
 
1. Create a query into this table.

2. Change it to an Update query (Update on Query menu).
Access adds an Update row to the grid.

3. In the Update row under the Post Code field, enter:
Replace([post code], " ", "")

4. Run the query.

You will need lots of spare disk space if this has 10^6 records.
 
Back
Top