# Re: SQL条件式

Posted by Mouse on October 13, 1999 at 13:24:36:

In Reply to: SQL条件式 posted by 小贤 on October 13, 1999 at 10:58:53:

: *.MDB 档 及 VB6

: 我要找 1999/1/1 至 1999/10/10 的资料,我下的条件式如下,但是找出的资料不正确.
: 只能用 " > , < " 条件式!
: 请问下面式子是哪里有问题呢?(建立日期的栏位型态是 Data/时间 )
:
:
: " Where 建立日期 Between 1999/1/1 And 1999/10/10 "

改成
Where 建立日期 Between #1999/1/1# And #1999/10/10#

Follow Ups:

- Re: SQL条件式 Joint 13:36:13 10/13/99 (1)
  - Re: SQL条件式 nothing 09:31:46 10/14/99 (0)