Sort Table On An expression 1

[Silvinho]

Is it possible to sort a table on an Expression Sum.
i.e: [SumOfLeague_Goals]+[SumOfCup_Goals]As Expr1

Then ORDER BY Expr;

Whenever i try this it fails.

 

[jebry]

Hi!

I have not had any trouble sorting on expressions, though I usually sort on a count and not a sum I wouldn't think that would make any difference. I noticed that your order by in the example referenced Expr instead of Expr1. I assume that is a typo and not the cause of your problem. Maybe you could post the SQL code that is causing problems?

hth
Jeff Bridgham

 

[tlbroadbent]

It appears that Access cannot resolve the aliases and treats them as parameters. I've not been able to make that particular query construct work. I suggest the following change.

Rewrite the expression as Expr1: [League_Goals]+[Cup_Goals] and select Sum in the Total row of the query designer so that Order By clause looks like the following.

ORDER BY Sum([League_Goals]+[Cup_Goals]);
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual.