Hi,
I have a field in a table that I imported a whole bunch of last names into. The names all have quite a few blank spaces at the end of each. So when I try to report with the last name field, The Last name pushes the first name off the page because of all the extra spaces.
Is there any easy way to delete all blank spaces after text? I'd rather not go through 4,000 individual records deleting the spaces after each last name!
Thanks in Advance,
Jeremy
I have a field in a table that I imported a whole bunch of last names into. The names all have quite a few blank spaces at the end of each. So when I try to report with the last name field, The Last name pushes the first name off the page because of all the extra spaces.
Is there any easy way to delete all blank spaces after text? I'd rather not go through 4,000 individual records deleting the spaces after each last name!
Thanks in Advance,
Jeremy