Tom Poje Posted February 9, 2006 Posted February 9, 2006 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})
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now