I'm used to being able to specify an order by in a view in other dialects of SQL. I find it handy.

Rather than Microsoft deprecating (or silently removing) TOP <big number> in the future, it would be nice if they would officially support an order by in a view.

Is there a particular SQL standard that dictates that order by cannot be specified in a view?

Re: my original post: I have defined the summarisation view w/o an order by, and a simple stored procedure selecting the view including an order by. I've researched Access <--> SQL Server more, and Access can use the SP as a (readonly) record source, so that will meet my needs. In this instance, it's fine that the record source is readonly in Access.

Thanks all for your replies.