Welcome Guest ( Log In | Register ) · 0 New Messages
![]() ![]() |
Feb 9 2006, 04:16 PM
Post
#1
|
|
|
Moderator Group: Sitewide Moderator Posts: 3,933 Joined: 26-August 98 From: Florida (land of hot humid summers) Member No.: 1,560 |
so, while you can sort by name, the sort is as follows:
if {PLANKMTEST.EESORTOPTCD}='2' then ({PLANEEKMTEST.LASTNAM} + {PLANEEKMTEST.SSNUM}) so when it sorts you get by name, but if two people have the same last name then it sorts by soc sec number. so my plan with a flock of Smiths is, well.... you would need to modify as follows if you want the first name to be considered in the sort. if {PLANKMTEST.EESORTOPTCD}='2' then ({PLANEEKMTEST.LASTNAM} + {PLANEEKMTEST.FIRSTNAM}+ {PLANEEKMTEST.SSNUM}) |
|
|
|
![]() ![]() |
| Lo-Fi Version | Time is now: 21st November 2009 - 03:30 PM |