Using FM 7.0v3
How can I sort records alphabeticly but have blank fields listed last

Gus

In article <dsWdnd_qO8hM5QjYnZ2dnUVZ_h2pnZ2d (AT) adelphia (DOT) com>, "Old Foggy"
<OldFoggy (AT) Foggy (DOT) com> wrote:

The easiest way would be to create a new Calculation field that copies
the original field's value or if the original field is blank uses
something that will alway gets sorted to the end.
eg.

SortField = If (IsEmpty(OriginalField),
"zzzzzzzzz",
OriginalField)

Use this field just for sorting the records, but use the OriginalField
whenever you need to display, print and change the data.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)