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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030731/6eee16ce/attachment.html>