Friday afternoon my manager brought to me a report that was leaving out one of our members. The report had 2 filters: one of them being a date field. I opened the table, browsed all members, and the member was there. I browsed using the 2 filters in the report, he wasn't there. Browsed using only one of the 2 filters, he's there. Browsed using the other (the date field), he's not. All of this is after proofing that the values in the fields being filtered are as expected. I even cut and pasted values from records that _did_ show up in the queries into the offending record to no avail. OK, I figure... something is messed up with the index, so after everybody went home, I reindexed. Voila! the member shows up. Well... s**t happens, so I went home. But today, there is another record in the same table that is doing the same thing. (but on different fields). What is going on? Could a funky piece of code cause an index to leave out records?
PLease help... this random 'forgetting' of records just will not do. Thanks

Erik