UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Eliminate Spaces    
 
   
Shiner452
post Mar 12 2008, 11:21 AM
Post #1

UtterAccess Addict
Posts: 132
From: Dallas
Is there a way I can create a query field that will take the spaces out of a field.

I want to turn this "Fifty five" into "Fiftyfive"
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 2)
Doug Steele
post Mar 12 2008, 11:23 AM
Post #2

UtterAccess VIP
Posts: 17,607
From: Don Mills, ON (Canada)
Use the Replace function:

Replace("Fifty five", " ", "")

I'm assuming that your value is actually in a variable (let's call it MyString), in which case you'd use

Replace(MyString, " ", "")
Go to the top of the page
 
+
Shiner452
post Mar 12 2008, 11:26 AM
Post #3

UtterAccess Addict
Posts: 132
From: Dallas
Awsome...you the man!
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 06:03 AM