Problem with findset

[GizmoGCHC]

I am not sure if anyone is going to be able to shed some light on this for me or not but I am at a loss here.

The problem I am having is this. I have a report that needs to be displayed that will only show reports from the fist of the month to the 30 or 31s of the month. The reports also need to be marked "NO" as we have a radio button box that requires the user to select yes or no. Reports with yes are left out of the report we want to display in a new layout.

Anyhow what is happen is we have one report that no matter what we do will not show up in a report out of 44 we would like to print and heres the thing. No matter what we enter into this box it will read it as if we have entered yes. I have tried blanking it out, I have tried replacing it with No and I even changed the radio buttons to a edit box and entered NO in it and still it will not show up if we search for all records that have NO in them but if we search for records with YES it finds it no matter what we enter into the box. When it shows up after we do a find set it shows up correct with "NO" when we only want to see reports marked YES.

Not sure if I am explaining this well enough, been a long day and this is something I just cant get my head around right now.

If anyone can help out or give me some ideas of what I might be able to try or do that might help please speak up.

[Fitch]

Corrupt index maybe? Try going to the Storage options for the field, set indexing to None, uncheck "Automatically create" and click OK, and OK to exit Manage Database.

Then go back into the options and set it to automatically create indexes and try searching again.

Just to be clear: you're doing a manual Find? Or is it part of a script?