sql:=select sum(销售额) as total form aa;然后把dbtext帮定 到字段total就可以了!
sql:=select sum(销售额) form aa;//执行到这时提示:field 编号 not found; 改为sql:=select 编号,sum(销售额) form aa;//执行到这时提示:you tried to execute a query that does not include the specified expression '编号' as part of an aggregate function。 请问这样的查询语句该怎么写??
双击adotable 或table加入固定字段再进行一些设置就可以了别我如query也一样
to qhf503(和风) adoquery 没有sqlbuilder补充: 编号为主键,类型为自动编号,数据库为access.
改为sql:=select 编号,sum(销售额) form aa;//执行到这时提示:you tried
to execute a query that does not include the specified expression '编号'
as part of an aggregate function。
请问这样的查询语句该怎么写??
adoquery 没有sqlbuilder补充:
编号为主键,类型为自动编号,数据库为access.