This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 有没有MS Access的牛人？用date field 做key的query时遇到 "date type mismatch" 的 message 是怎么回事？明明两边都是日期。尤其是用DateSerial()时更易出现。现在一见date key就发醋。请点拨一二。
-ado(共产主义接班人);
2003-10-22
(#1426868@0)
-
是不是因为你日期的格式不对?比方说应该用:
select * from mytable where mydate=#2003/10/22#
而不能用:
select * from mytable where mydate="2003/10/22"
-antelephant(蚂蚁与大象);
2003-10-22
{124}
(#1427504@0)
-
I am testing whether it has anything to do with NULL value. I need to modify permanent query behind a form:
-ado(共产主义接班人);
2003-10-23
{541}
(#1428663@0)
-
beats me.
-antelephant(蚂蚁与大象);
2003-10-23
(#1429083@0)
-
I also have this problem, so everytime I check the value first, if is not NULL, I will exeute the query, otherwise not....
-shinning(dudu);
2003-10-23
(#1429275@0)