unless there is file damage, the only reason for no field in the answer is when there are no values in the field or no values in the result.. when you run "the same query" with different results, that usually means that something is wrong.. most likely, damaged or out-of-synch index files..
make sure you have backups.. rebuild with the repair tool.. restruct to pack the table and rebuild the indexes.. validate the results..
Steven Green - Myrtle Beach, South Carolina USA
Oasis Trading Post
- Collectibles and Memorabilia
- Vintage Lego Sets and Supplies