order by alias name

[MattLewis]

Does Access SERIOUSLY not support an order by clause that uses a column alias name?????

SELECT Job, SortableJobNumber(Job) AS [Job Number]
FROM Jobs
ORDER BY [Job Number];

Access is asking me to enter a parameter value for [Job Number] ?????????? This is basic SQL 101 stuff here, What the ever-loving Christ is wrong with Access?

[ranman256]

Access doesn't care about the alias, only humans do.
So put the real field name.

[JoeM]

Or you can just use the field reference. Since it is the second field in your Select query, you could just use:

ORDER BY 2;

[aytee111]

Please keep this forum clean, hopefully someone will edit his post.