criteria referring to calculated field in same query 1

[simon551]

Hey all,
Is it possible to set a criteria based on a calculated field in the same query. Referring to the calc field's name?

 

[lespaul]

you can't refer to the name, but you can reuse the actual calculation:

Won't work:

Select Id, Sum(ID) As SumOfID
From SomeTableName
ORDER BY SumOfID

Will work:

Select Id, Sum(ID) As SumOfID
From SomeTableName
ORDER BY Sum(ID)


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[simon551]

Thank you. I appreciate it.

-simon

 

[lespaul]

no problem, thanks for the star, hope you got it working!

les