Appleworks 6 Database


I have created a database with 3 number fields and 2 text fields, sorting variously in numerical order of a-z as required.

However, when sorting a-z I wish to eliminate number fields which do not have text fields attached: in other words, some number fields currently have blank text fields awaiting information.

Currently, all such number fields with blank text fields appear at the beginning of the Sort: how can these number fields be eliminated from the a-z Sorts?

database holds 1064 records, 142 of which currently have blank text fields.

I use a Mac mini
Update from questionner: I have come to the conclusion that the only way to deal with the problem is to save the file again and then actually delete the blank text records, thus having one file of numberical and one of a-z records only.