Trimming blank space

[AccessHawaii]

I just imported some data from the spreadsheet and it's in pretty bad condition. The biggest problem being that theres a lot of blank spaces. For example if I try to concatenate the first name and last name together it will come out looking something like this "John Smith"

Does anyone know a simple way to get rid of the spaces? Thanks.

 

[Blorf]

Use the trim and Ltrim function. Trim eliminates spaces at the end, Ltrim for the begening.

So in a query, you have lastname and first name. So whole name would be:

WholeName: trim(Lastname) & ", " & trim (Firstname)

ChaZ

Ascii dumb question, get a dumb Ansi

 

[AccessHawaii]

Thanks, worked great.

 

[MichaelRed]

but, to be somwhat more 'precise' in the discription of the functions referenced, see the ubiquitous {F1} (a.k.a. Help).




MichaelRed
m.red@att.net

Searching for employment in all the wrong places