Quote Originally Posted by June7 View Post
Not sure what Avril's ORDER BY 2 ASC will do. Maybe should be ORDER BY Lastname, Name
In queries, you can use the order number of query field in "ORDER BY" or "GROUP BY" clauses instead of field name. So in my combo's rowsource query, this did order the query result ascending by 2nd field of result table. I don't advice to use this everywhere, but in combo's rowsource it will be OK!