You can certainly use ORDER BY in an MS Access query (type it in SQL or enter the sort sequence in the GUI in the design view). As most or all of your questions are about MS Access, I don't grasp the problem.
Here's my Access query (where member is a table in the database, but it could be another query, or a table in another database, or even a table or a view in an SQL Server database, as far as I know): SELECT Member.member_id, Member.last_name, Member.first_name FROM Member ORDER BY Member.last_name
Can you clarify your problem?
i have a view in my sql database and I would like to order one of my columns, but I am receiving an error saying that you cannot use ORDER BY in a sql view. is there a way around this by using a different command ?
thanks in advance