Thanks everyone! Here's an example using Sql in Access

SELECT MEMBERS.FNAME, MEMBERS.LNAME, MEMBERS.MNAME, MEMBERS.SNAME, Mid(FNAME,2,1) AS Expr1, Right(LNAME,1) AS Expr2 FROM MEMBERS ORDER BY MNAME, Mid(FNAME,2,1), Right(LNAME,1);