sorting by calculated field

[sevex]

I'm trying to sort a query by a calculated field, but it's giving me a "field doesn't exist" error. Is there a special way of doing this?

My example (Coldfusion):
SELECT *, (#Now()# - target_completion) AS days_left FROM TJob ORDER BY days_left

target_completion is a date field. I can output "days_left" and it appears correct.

thanks in advance

 

[AWithers]

I just tried a similar thing in Access and regardless of the whether you giuve it an alias it actually puts the calculation in the order by clause e.g. in your case

SELECT *, (#Now()# - target_completion) AS days_left FROM TJob ORDER BY #Now()# - target_completion

Andy

 

[jebry]

Hi!

You have to do it like this:

SELECT *, (#Now()# - target_completion) AS days_left FROM TJob ORDER BY (#Now()# - target_completion)


hth
Jeff Bridgham
bridgham@purdue.edu

 

[sevex]

blah, why didn't I try that.... thanks for the help!