TRIMING UNWANTED SPACES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

EXAMPLE RETURN
10- 00-00-00 10-00-00-00
120- 00-00-00 120-00-00-00
7000- 00-00-00 7000- 00-00-00
 
-----Original Message-----
EXAMPLE RETURN
10- 00-00-00 10-00-00-00
120- 00-00-00 120-00-00-00
7000- 00-00-00 7000- 00-00-00
.
=trim(10- 00-00-00)
Click to expand...
 
Use the Replace function in an Update Query to replace " " with zero-length
String "".

If you use AXP, no prob. If you use A2K, there is a bug in using Replace()
in a Query so you need to write a simple wrapper function. If you use A97,
Replace() is not available but a custom Replace() has been posted in these
newsgroups previously.
 
Larry

Trim only removes spaces at the beginning or the end of the expression but
leaves the spaces in the middle.
 
EXAMPLE RETURN
10- 00-00-00 10-00-00-00
120- 00-00-00 120-00-00-00
7000- 00-00-00 7000- 00-00-00
Click to expand...

7000-00-00-00 I presume you meant here?

What version of Access? IF you're using AccessXP or later, update the
field to

Replace([fieldname], " ", "")

If you're using 2000 or older post back with your version (without the
Caps Lock key please). It's doable but takes some code.
 
You must log in or register to reply here.

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

Changing constants in a query to user input values 2
Count records in 10 minute time period 4
querying unrelated tables 7
Update End Date 5
Time calculation 2
Query to find records after specific date and time today 10
How to get a signal from the Task Scheduler 3
Pivot Table needed that groups part numbers and dates 2

Back
Top