 | |
#1
 
| |||
| |||
|
Re: Sort Question -
08-08-2003
, 06:17 PM
|
I have a file of names & Business names that when I sort them they sort properly. My question or problem is when I sort those names that are not associated with a business name always are at the top of the list which is correct alphabetical, I would like them not to show. I think it can be done using "ISEMPTY(file)" thru an "IF" statement but I don't know how to tell it if the field of business is empty not to list it. I may also be wrong! FYI Using FileMaker Pro 6.2 - PC Windows 2000 Operating System only. Thank You Charlie |
If you want to display a list with some records not showing, then first
perform a find, then sort the found set.
--
Henk B
#2
| |||
| |||
|
|
I have a file of names & Business names that when I sort them they sort properly. My question or problem is when I sort those names that are not associated with a business name always are at the top of the list which is correct alphabetical, I would like them not to show. I think it can be done using "ISEMPTY(file)" thru an "IF" statement but I don't know how to tell it if the field of business is empty not to list it. I may also be wrong! You need a Sort field. This is a calculation field in which you |
only used for sorting. For instance, when sorting surnames, I always use
a Sortfield so that I can change Mc to Mac so that McKenzie and
MacKenzie will sort together. No-one ever sees this field.
Your calculation for the Sort field should be something like:
If(IsEmpty(businessname), "zzz", businessname)
What this does is give you a field in which you get the businessname if
it exists, otherwise, zzz. Now sort on Sortfield followed by Fullname or
surname (to get the several people in each business sorted properly) and
you will get all the businesses at the top and all the ZZZ people at the
bottom.
Maire Black
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.