access数据库的sql怎样判断字段为null

[chaozhou]

access数据库的sql怎样判断字段为null

创建表table1 时候，字段one1默认值为null

在用sql打开记录时候 我想one1记录为null为条件的记录，怎样实现啊？

where [one1]=null 或者 where [one1] is null 都是错误！怎样弄呢？
谢谢

[sy_binbin]

where [one1] = ""
这样就可以了

[php_wsd]

where one1=''
这样呢?

[搬运工865]

one1 is null
one1=""
is mull(one1)

你挨个试吧~~~

[mark271828]

"创建表table1 时候，字段one1默认值为nul" ，如果字段one1默认值为字母"null"的话，你可以试下select * from table where one1="Null"
本地测试成功

[gingerkang]

is null

[qlc263]

if(rs("字段名")&"a"="a") then
response.write "空值"

[suano]

where isnull(one1)试试,isnull是vbs函数

[jykgps]

isNull(one1)

[yzx65]

one1="Null"

[shanxmxj]

select distinct table1.地点,iif(isnull(table2.表达式1),0,table2.表达式1) from 表1 table1

left join

(SELECT t2.地点, Sum(数量) AS 表达式1
FROM 表1 t2
WHERE (((t2.种类)="甲"))
GROUP BY t2.地点
)
table2
on table1.地点=table2.地点;