Getting bad search results

[PRS2DGT8OR]

Let me try to adequately describe this issue. I have a database for our magazine advertisers. I have created a text field of check boxes, Sept. 08, Oct. 08, Nov. 08, etc... These are the months that the advertiser's ad will run in the magazine. I have tried specifying these as dates, but it will not allow the input because they are not full dates, i.e. 05/25/2009. When I perform a search of say just Jan. 08, it also returns records that do not have Jan. 08 checked, but have Jan. 09 checked. I need to be able to search for just the records that have Jan. 08 checked and not Jan. 09. The problem is I cannot do an exclude search because some of the records I need to find have both Jan. 08 and Jan. 09 checked. This happens with all months, Oct. 08 and Oct. 09, May 09 May 08, etc. Any ideas on why Filemaker is returning Jan. 09 records when I search for Jan. 08?

Edited December 11, 2007 by Guest

[Stuart Taylor]

have you made a copy of the field with the checkbox valuelist removed. You may find other data is contained in the field that do not meet the criteria of your valuelist, but do meet the criteria of the search.

[PRS2DGT8OR]

Just did that and there is no errant data in the field. I think I did it correctly. Can you walk me through it?