By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,717 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,717 IT Pros & Developers. It's quick & easy.

Disappearing records when sorting

P: 12
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..........
Feb 23 '08 #1
Share this Question
Share on Google+
2 Replies


mshmyob
Expert 100+
P: 904
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.

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..........
Feb 23 '08 #2

P: 12
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 anyway
Feb 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.