[thelist] Access & SQL

[Rudy_Limeback at maritimelife.ca]

> I'd like to select, (and order by), a formula ....
>
>   SELECT (OHQTY * MLO_COST) as XTD_VALU 
>     FROM ITEMMAST
> ORDER BY XTD_VALU

hi ron

use ORDER BY N1, N2,... where the N's are the position numbers within the 
SELECT list of the columns you want to order by

in your case ORDER BY 1


rudy 
r937.com