Update query to remove leading space from address field

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

How do I use an update query to remove a leading space
from an address field? The file is large (over 17,000
records), and most, but not all records have the space.

Thanks for your help!
 
Take a look at the Trim() function in Access HELP.

You can probably get away with updating the address field (let's call it
[DeliveryAddr]) to:

Trim([DeliveryAddr])

Good luck

Jeff Boyce
<Access MVP>
 
-----Original Message-----
Take a look at the Trim() function in Access HELP.

You can probably get away with updating the address field (let's call it
[DeliveryAddr]) to:

Trim([DeliveryAddr])

Good luck

Jeff Boyce
<Access MVP>

.
Click to expand...
Every time I try this, I get a compile error. I also had
run some other update queries that ran successfully at
first, but when I tried to run them again I got the same
compile error. Is it possible I need a patch for a bug in
the program?

Thanks

JK
 
Judy

Back to basics...

Which version of Access are you running, which SP/SR/patch level, on which
operating system, which SP/SR/patch level?

Jeff Boyce
<Access MVP>
 
Back
Top