如下代码,在sql中好用,access中怎么实现?

[cyh19820115]

select bkalias,sum(qty) as qty from outdtl
group by bkalias
order by qty desc

[cheny1234]

只要是相同的表名和字段名，access就可以用这条sql语句。

[changechange]

select bkalias,sum(qty) as qty1 from outdtl
group by bkalias
order by sum(qty) desc

[liuyann]

select bkalias,sum(qty) as qty1 from outdtl
group by bkalias
order by qty desc

换个字段名

[cheny1234]

我不会delphi，但recordset应该是一样的吧！试试其属性：recordsource="select bkalias,sum(qty) as qty1 from outdtl group by bkalias",sort="qty1 desc"

[cyh19820115]

to changechange(改了又改) wydpz(lily) () 对了

select bkalias,sum(qty) as qty1 from outdtl
group by bkalias
order by sum(qty) desc

[wydpz]

你可以用这个试试：
select bkalias,sum(qty) as qty1 from outdtl
group by bkalias
order by sum(qty) desc

[cyh19820115]

在delphi的adoquery中,直接用上述语句产生错误提示:
"试图执行的查询中不包括作为合计函数一部分的特定表达式'qty'"
怎么回事?

[cyh19820115]

select bkalias,sum(qty) as qty1 from outdtl
group by bkalias
order by qty1 desc

改为上代码,错误"参数qty1没有默认值"

[cyh19820115]

select bkalias,sum(qty) as qty1 from outdtl
group by bkalias
order by "qty1" desc

改为上代码,没错误提示了,不过排序结果不对,跟不排序顺序一样!
????