Sort Calculated field

Hello to everyone

I would like to know if the Dao Jet Engine allows to use AS clause in a query. I have a DaoRecordset and I would like to sort
it with an a field resulting by a function, Can I do a select with a function like that:

Select *, SetValue([Score],[Priority]) AS [Post]
FROM Employee
ORDER BY [Post]


Is Someone can Help me, Please