I have a table that has started to give bad results on a select query. If I run a query I get noo records or every record depending on my critiera. In reality I should get about 200 records out of 10000. There are no error messages or other indication of a problem. If I create a similar table and append the records form the corrupt table the second table gives the correct results.

So it appears that I have a corrupt table. What is the best way to salvage this table? Built in tools or third party?

Thanks

Dennis