[AccessD] Remove spaces from field

Mark,

If your actual data is like your example then your problem seems to be
three items stored in one field instead of three fields.  That's a No-No
to us normalization purists.  <VBG>  If you are planning to move the
three items to three fields, then the Split() function should do nicely.
If not, then maybe the Replace() function will do.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] 
Sent: Thursday 2003 Jul 31 12:44
To: AccessD at databaseadvisors.com
Subject: [AccessD] Remove spaces from field

How can I remove any spaces from data in a field?
For example, Field1 contains 'johnsmith   01/01/1995 ABC'.  I want the
field to be 'johnsmith01/01/1995ABC'.
Any suggestions?

Thanks,
Mark Boyd
Sr. Systems Analyst
McBee Associates, Inc.