L
Luting
Hi all,
I have an error when using the function dateAdd(). Here is my sql
statement:
SELECT FLINK_N_OPERLOG.*
FROM YQPW, FLINK_N_OPERLOG
WHERE (((FLINK_N_OPERLOG.TMSTAMP)>=" [Forms]![YQPW]![BEGIN]" And
(FLINK_N_OPERLOG.TMSTAMP)<=DateAdd("n","20",[Forms]![YQPW]![BEGIN])));
The error says:
This expression is typed incorrectly, or it is too complex to be
evaluated.
How can I fix it?
Is DateAdd("n", "20", sth.)=sth.+20(min)?
Thanks in advance.
I have an error when using the function dateAdd(). Here is my sql
statement:
SELECT FLINK_N_OPERLOG.*
FROM YQPW, FLINK_N_OPERLOG
WHERE (((FLINK_N_OPERLOG.TMSTAMP)>=" [Forms]![YQPW]![BEGIN]" And
(FLINK_N_OPERLOG.TMSTAMP)<=DateAdd("n","20",[Forms]![YQPW]![BEGIN])));
The error says:
This expression is typed incorrectly, or it is too complex to be
evaluated.
How can I fix it?
Is DateAdd("n", "20", sth.)=sth.+20(min)?
Thanks in advance.