finding a number in a number field

[nad1]

I am sorry I am still with 8.5 folks.

I guess I am a little behind.

This is my issue: I am really surprised that I do a search for a specific number in a number field.

So, we all know that if found, that specific number will show up on the screen.

Well, instead, it finds that number plus a few others.....

I did the recovery of the file, but it continues doing that.

Does anyone have a way to know the reason for this happening?

I will be happy to hear from you guys!

Thanks in advance

ND

 

[nad1]

Let me respond to myself. That way, you know the reason why I am still in 8.5.

Table content was fed by data from another table with (believe or not ) repeating fields. I imported this data and did not choose the option to split the contents into different records, so when searching into the number field for a specifc number, it found that number plus all the other data in that record. Well I hope I didn't waste anybody's precious time in this issue.

[Fitch]

Automatic message

This topic has been moved from "Peer To Peer Sharing" to "Finding & Searching".

[Kris M]

What do you mean by "a few others"? Give us a solid example and someone will explain.

For example...are you searching for 2 and it returns 23, 342, and .3452?

Or you seacrh for 2 and it returns 75, 896, and .3457?