How do I TRIM a field in existing fields....?

K

Kelvin Beaton

I didn't realize when I imported some data into my database that there were
a bunch of spaces after all the data.

I know that I can do a RTRIM the data in a query, but I don't want to have
to remember every time I create a query to TRIM it.

Do I have to use a query and make a temp table and then delete the data from
my original table and then put the data back in from my temp table.
I can do this, but wanted to know if there is a better way.

Thanks

Kelvin
 
J

Jeff Boyce

Kelvin

A standard approach to importing (and "cleaning") data is to import/append
to a temporary table, then use queries to parse the data into your
permanent, well-normalized tables. In this process, the Trim() function
(which would take care of both leading and trailing spaces) can easily be
added.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

Kelvin Beaton

Thanks Jeff

I get that I did this backwards, but was hoping there was something I could
to with my mess now.

Is there anything like search and replace?
I jext need to delete all the spaces in each field.......

Thanks

Kelvin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Dates In Excel 5
Creating a Search using a combo box and then creating a report. 4
Creating a Chart on form from selected data in query. 0
How to Create an S-Curve from Custom Field? 0
Creating Network Diagram using a Chart SW integration 0
Create a dynamic master file 1
Create a chart from a table in word thats dynamic 0

Top