I have an Access table with many records and fields. Something occurred in the last few days I have never seen before. When opening the table in Datasheet View it appears that some values in Field1 were placed in Field2 and were then either deleted from Field1, or the values in both fields were swapped. This is also what appears when looking at the records through a form bound to the same table. However, when using a select query to view these same records no such thing appears. The select query displays the records exactly as they should appear.
Since the select query displays the records as expected I'm not able to change the data in the table. Normally I would update values from Field2 to Field1 to fix this but the select query doesn't find any records that match what appears to be wrong in the table.
I have no clue what is causing this. No error messages occur and everything looks and works fine. The table is compacted weekly and, in fact, was compacted last night. Any suggestions to solve this would be greatly appreciated.