UC知道access 中想让空值显示成0用NZ（）怎么做？
来源：百度知道 编辑：UC知道 时间：2024/05/03 04:23:36
比如我想让下面的MEDAL.Cont_id为空时，显示成0，该怎么办~
SELECT COUNTRY.Country_id AS COUNTRY, COUNT(MEDAL.Cont_id) AS SLIVER
FROM ((COUNTRY INNER JOIN REPRESENTATIVE ON
COUNTRY.Country_id=REPRESENTATIVE.Country_id) INNER JOIN CONTESTANT ON REPRESENTATIVE.Rep_id=CONTESTANT.Rep_id) INNER JOIN MEDAL ON CONTESTANT.Cont_id=MEDAL.Cont_id
WHERE MEDAL.Medal_color LIKE 'Sliver'
GROUP BY COUNTRY.Country_id;
SELECT COUNTRY.Country_id AS COUNTRY, COUNT(MEDAL.Cont_id) AS SLIVER
FROM ((COUNTRY INNER JOIN REPRESENTATIVE ON
COUNTRY.Country_id=REPRESENTATIVE.Country_id) INNER JOIN CONTESTANT ON REPRESENTATIVE.Rep_id=CONTESTANT.Rep_id) INNER JOIN MEDAL ON CONTESTANT.Cont_id=MEDAL.Cont_id
WHERE MEDAL.Medal_color LIKE 'Sliver'
GROUP BY COUNTRY.Country_id;
Nz 就是让空值变为 0 的函数。上面的语句看到我头都晕，不细看了。
该函数一般用在表达式里，格式：=Nz(表达式)。如果表达式计算的结果为空，那么就赋值 0 ，否则就是原表达式结果。