I've got a table with about 153,000 records. One of the fields is "Header_ID" . I'm looking for Header_ID 3118. So, if I do a find, it locates it for me...and that's fine. However, if I then sort on that field, the FIND function cannot find it, nor can I find it by scrolling down. Not only that, but then, there are only about 123,000 records. I'm totally lost..........
-
-
Show us your code for the FIND method.
Is your Header_ID a Number or Text field. If a Text field do you use ' anytime?
You could also try compacting and repairing your database to see if it is corrupted.
Originally posted by dbanalyst -
The first thing I tried was compact/repair. (Btw, the Header_ID is a long int.)
I'm thinking it was a corrupt record. Scrapped the table and reimported from sql table and is fine now. (That was the strangest thing) Thanks anywayComment
Comment