Update query to remove leading space from address field

[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!

 

[Jeff Boyce]

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>

 

[JK]

-----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>

.

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

 

[Jeff Boyce]

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>