[AccessD] Trim in Access 2007

Hi Gustav,

I am doing the common operation of trimming fields that have
extra spaces in them. These probably came from a fixed-width
text-file, but I only receive the accdb. 

I execute the query and it has no effect on the spaces.

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Friday, November 30, 2007 9:31 AM
Subject: Re: [AccessD] Trim in Access 2007


> Hi Michael
> 
> Haven't followed this thread until now. 
> Could you explain what you try to do? Clear as mud for me ...
> 
> /gustav