Access中可以插入时比最小值小于1吗？

我这样写未指明的错误：
SQL code:
((select min(pview) from DSolution)-1)

---

select min(pview)-1 from DSolution

---

引用

select min(pview)-1 from DSolution

正解。

---

insert into table1 (myvale) select min(pview)-1 from DSolution

---

SELECT DICTINCT (SELECT MIN(pview)
from DSolution)-1 from DSolution
OR
select min(pview)-1 from DSolution

---

引用

select min(pview)-1 from DSolution

多谢了
这样写为什么不行啊：

SQL code:
insert into Dsolution(PID,PView) values(16,(select min(pview)-1 from DSolution))

---

insert into Dsolution(PID,PView)
select 16,min(pview)-1 from DSolution

---

哦，试下，Access中不知道这种语法能不能用哦

---

引用

insert into Dsolution(PID,PView)
select 16,min(pview)-1 from DSolution

非常感谢，