如何让交叉表中的空值为0?等待中.....

deven1116

在附件的交叉表查询中,如何让空值为0呀,

wwwwa

TRANSFORM nz(Sum(输入数据.M8),0) AS M8之Sum
SELECT 输入数据.生产线
FROM 输入数据
GROUP BY 输入数据.生产线
PIVOT 输入数据.数据来源;

accessNew001

麻烦WWWA看一下这段程序为什么我运行就提示我说： 用于函数参数个数不对 在查询表达式：nz(Sum([2004Union2005].Quantity,0))中  谢谢！

TRANSFORM nz(Sum([2004Union2005].Quantity,0)) AS [sum]
SELECT [2004Union2005].Customer, [2004Union2005].city
FROM 2004Union2005
WHERE Val(Left([Customer],2))<90 And [2004Union2005].customer Like "10*"
GROUP BY [2004Union2005].Customer, [2004Union2005].city
ORDER BY Format([month],"00") & [year] & Format([date],"mmm")
PIVOT Format([month],"00") & [year] & Format([date],"mmm");

  

accessNew001

怎么不回答我呢

wwwwa

TRANSFORM nz(Sum([2004Union2005].Quantity),0) AS [sum]
SELECT [2004Union2005].Customer, [2004Union2005].city
FROM 2004Union2005
WHERE Val(Left([Customer],2))<90 And [2004Union2005].customer Like "10*"
GROUP BY [2004Union2005].Customer, [2004Union2005].city
ORDER BY Format([month],"00") & [year] & Format([date],"mmm")
PIVOT Format([month],"00") & [year] & Format([date],"mmm");

建议你学习一下ACCESS、JET SQL的函数。