# 1552 Record Counts Greater Than Number of Records in Table When Certain Filters Applied to a Table

---

It would appear that if you have an Index on a field and you run a filter on that field, the RecordCount gets corrupted. My TagBoardPeople table has a secondary index on SiteID. If I run a filter of "SiteID = X", my RecordCount & FilterRecordCount are greater than my PhysicalRecordCount! If you then alter the table to delete the SiteID index and run the program again the counts return correctly.