N
news.telenet.be
I have an access database which is converted from filemaker on macintosh. In
some fields at the end of the field I have some characters acting like
returns, but I don't know what they are. I want to delete them by replacing
them with nothing or with an update query but access doesn't seem to find
the characters. Is there a way to find those characters and replace them
with nothing. I want to trim the fields so they're gone. Whenever I try to
make a report they are very annoying.
Thanks in advance.
An example can be found here:
http://users.pandora.be/jochen.scheire/test.zip
some fields at the end of the field I have some characters acting like
returns, but I don't know what they are. I want to delete them by replacing
them with nothing or with an update query but access doesn't seem to find
the characters. Is there a way to find those characters and replace them
with nothing. I want to trim the fields so they're gone. Whenever I try to
make a report they are very annoying.
Thanks in advance.
An example can be found here:
http://users.pandora.be/jochen.scheire/test.zip