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
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