I have a query that lists names, functions, primary/Alternate/Reference, and contact information.
I have successfully built queries from the main query to break out the specific "functions". I would like to further sort those queries by "P" then "A" then "R". Obviously sorting by ascending or decending doesn't work becauses of the third choice.
Any thoughts.
thanks,
I have successfully built queries from the main query to break out the specific "functions". I would like to further sort those queries by "P" then "A" then "R". Obviously sorting by ascending or decending doesn't work becauses of the third choice.
Any thoughts.
thanks,