★★★★大哥大姐们！救命呀！这个问题真的好难呀！★★★★

[lovemei_80]

首先谢谢大哥们！昨天一天没有睡觉，昨天晚上也没有睡觉。今天还是没睡觉。

头脑真的不行了！帮忙想想。如何实现如下效果！

Sql=" Select max(S_id) as S_id, S_c_name, SUM(IIf(Year(S_time)="&YearId&",S_money,-0)) AS ShowMoney From sell group by S_c_name "

Rs.open Sql, Conn, 1, 1

上面的语句没有错误。
ShowMoney 为：相同的 S_c_name（姓名），每次购买物品金额 S_money 的总和！

我现在想做一个条件查询

也就是 加 where 总金额 > 某个值

这个怎么写呀！！！

WHERE 子句 中不能有合计函数。所以这个where不知道怎么写了。帮个忙！

[yingqing]

seletc * from (Select max(S_id) as S_id, S_c_name, SUM(IIf(Year(S_time)="&YearId&",S_money,-0)) AS ShowMoney From sell group by S_c_name )b where showmoney>

[lovemei_80]

seletc * from (Select max(S_id) as S_id, S_c_name, SUM(IIf(Year(S_time)="&YearId&",S_money,-0)) AS ShowMoney From sell group by S_c_name )b where showmoney>
什么意思呀？
看不懂！

[Andy__Huang]

Sql=" Select max(S_id) as S_id, S_c_name, SUM(IIf(Year(S_time)="&YearId&",S_money,-0)) AS ShowMoney From sell group by S_c_name having SUM(IIf(Year(S_time)="&YearId&",S_money,-0)) >某個值 "

[lovemei_80]

回复人： hdhai9451(Water Space--海洋空間) ( ) 信誉：100
老大，高！