Invisible trailing data in a text field

[gblack]

OK somehow someone has entered data into a text field that doesn’t show up in the table or queries.

For example: I have a table called Contacts and in it is a text field called CompanyName.

When I do a: Select Distinct CompanyName from Contacts. . .

The company name Adelphi shows up 3 times. . .The reason is that somehow there is embedded data (not visible to me but visible to the query).

The true records are:
“Adelphi”
“Adelphi (formerly X)”
“Adelphi (formerly X company)”

But the Query shows me:
Adelphi
Adelphi
Adelphi

So I have three questions:
1st) How is this possible? (I’ve never seen this before)
2nd) How do I get rid of this feature for the end user who enters the data through a form?
3rd) How do I get all the current data to show all the hidden stuff???

 

[saintsman]

I would look again at your query. They only show what you ask for and you may have put something in the criteria that limits what you see. The three Adelphis are different and you are probably seeing the first one three times and not seeing the last two. Check your table to see how many times Adelphi on its own comes up.

Don't be afraid to start again if it doesn't work.