求类似sqlserver中isnull()函数在access中如何实现

isnull(a,b)
即如过字段a为null则返回b
eg:
select isNUll(a,b) from table_1;

---

直接 IFNULL就行了。

SQL code:
mysql> select ifnull(null,2);
+----------------+
| ifnull(null,2) |
+----------------+
| 2 |
+----------------+
1 row in set (0.01 sec)

mysql> select ifnull(1,2);
+-------------+
| ifnull(1,2) |
+-------------+
| 1 |
+-------------+
1 row in set (0.00 sec)

mysql>

---

楼上看错了。ACCESS的话，则可以用1楼的或者用 NZ()
select NZ(a,b)