TRANSFORM Sum(Sheet1.mcount) AS mcount之Sum SELECT Sheet1.mname FROM Sheet1 GROUP BY Sheet1.mname PIVOT Sheet1.mdate
TRANSFORM Sum(Sheet1.mcount) AS mcount之Sum SELECT Sheet1.mname FROM Sheet1 WHERE (((Sheet1.mdate)>#3/1/2002#)) GROUP BY Sheet1.mname PIVOT Sheet1.mdate;
mname mdate mcount
TTTT1 2002-3-1 1000
TTTT2 2002-3-1 2000
.
.
.
对不对,然后呢?
SELECT Sheet1.mname
FROM Sheet1
GROUP BY Sheet1.mname
PIVOT Sheet1.mdate
SELECT Sheet1.mname
FROM Sheet1
WHERE (((Sheet1.mdate)>#3/1/2002#))
GROUP BY Sheet1.mname
PIVOT Sheet1.mdate;
小弟学编程只有几年,可能算法一词,还不算太清楚,所以请你包含,不过你可以藐视我的能力,但请不要侮辱我,这点请你记住,人都是有尊严的To:hideakiwang()
我查了一下Sql中的帮助,好像没有关于TransForm和Pivot的说明,能详细的说一点么,另外你查询的时候是一个日期查询的,而我要的是一段日期,还请详细说明一下