I am doing a Find on a date range. That works just fine. BUT when I do a Sort, even manually, it does not sort. It does change the order of the Found but not in alphabetical order.

The fields I have are LNameFName and Exam Date

So manually I entered a date range and did the Find. Then I did a sort on the LNameFName but it just seems to stir it up, not sort.

What simple thing am I overlooking?

Hello Don,

A few things to check:

1. Is the 'LNameFName' field defined as a text field (or if a calc, is it set to produce a text result)?

2. What indexing method is selected (in 'storage' tab of the field options dialog)?

3. Is your Sort definition for the LNameFName field set to 'Ascending' (you may be applying a 'custom' sort)?

If your field is defined as text, the indexing option is 'English' and your sort is defined as ascending and you are still not getting an alphabetical sort, then I would suspect a corrupted index for the field you are sorting on. In which case you should try deleting the index (ie turn indexing off, close the file, open it and turn indexing on again).

I knew it was something simple I was overlooking. The field is a calculation field but I forgot to make the result TEXT. sigh.

TANX!