大家好:
本人在ADOQuery的SQL中写入如下代码:
select string(year(SO_Date)) + string(month(SO_Date)) as 日期,
sum(SO_Money)
from TO_SaveOut
where SO_Flag = 'o'
group by string(year(SO_Date)) + string(month(SO_Date));
确总是报错,请各为大狭指点一二,不胜感激。谢谢!
本人在ADOQuery的SQL中写入如下代码:
select string(year(SO_Date)) + string(month(SO_Date)) as 日期,
sum(SO_Money)
from TO_SaveOut
where SO_Flag = 'o'
group by string(year(SO_Date)) + string(month(SO_Date));
确总是报错,请各为大狭指点一二,不胜感激。谢谢!
sum(SO_Money)
+' from ' + TO_SaveOut
+ ' where SO_Flag = ''o''
group by ' + string(year(SO_Date)) + string(month(SO_Date));
试下
'string' 不是可以识别的 函数名。
select convert(varchar(6),SO_Date,112) as 日期,
sum(SO_Money)
from TO_SaveOut
where SO_Flag = 'o'
group by convert(varchar(6),SO_Date,112)
我用的是Access数据库。但在Access中有text()函数,却不能使用。
我想实现的是将每年的不同月份的金额取出来,在进行汇总。
还请各位不吝赐教。谢谢
sum(SO_Money)
from TO_SaveOut
where SO_Flag = 'o'
group by cast(char(6),str(year(SO_Date)) + str(month(SO_Date)));