Order by expression (1 Viewer)

[Haynesey]

Hi,

Is there anyway that you can order a query to be descending by an expression in your query rather than an actual field from a table. I am trying to do this but the following message keeps appearing:

The Microsoft Jet database engine does not recognize '[ExpressionName]' as a valid field name or expression.

Any ideas?

Thansk in advance.

Lee

 

[petehilljnr]

Why not evaluate your expression in another field and order by that field?
Or have I missed something?